I haven't tried coding for Hive, so I am definitely not familiar with it. You can try to adjust your prompt, since I've heard it can change its result multiple times. Maybe the next ones will work? haha. Chatgpt still needs a lot of work, and that is why I've heard those who use it for programming still employ a veteran programmer to fix the codes.