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
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