Hi I am new to hive and we have a requirement for converting terra-data queries to hive queries. So i was successful converting them.. so far..... but now i have a teradata query that has BETWEEN operator in it, i don't know how to convert using hive equi-joins.. can someone help me??
here is my query: SELECT * FROM account a, timezone g WHERE a.create_date BETWEEN g.start_date AND g.end_date ; =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
