Re: Running the HiveQL from the shell prompt.

2012-08-07 Thread Raihan Jamal
Thanks Jan for the suggestion. *Raihan Jamal* On Tue, Aug 7, 2012 at 10:01 PM, Jan DolinĂ¡r wrote: > The shell will interpret the query in your command as SELECT > ... explode(split(timestamps, *#*)) ... if you run it the way you wrote > it, i.e. without the quotation. The way around this i

Re: Running the HiveQL from the shell prompt.

2012-08-07 Thread Jan DolinĂ¡r
The shell will interpret the query in your command as SELECT ... explode(split(timestamps, *#*)) ... if you run it the way you wrote it, i.e. without the quotation. The way around this is to either escape the quotation marks or use single quotes: hive -e *"*SELECT user_id ,product_id ,prod_and_ts