Thanks Jan for the suggestion.
*Raihan Jamal* On Tue, Aug 7, 2012 at 10:01 PM, Jan Dolinár <dolik....@gmail.com> 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 is to either escape the > quotation marks or use single quotes: > > hive -e *"*SELECT user_id > ,product_id > ,prod_and_ts_split > FROM ( > SELECT * > FROM ( > SELECT user_id > ,prod_and_ts.product_id AS product_id > ,prod_and_ts.timestamps AS timestamps > FROM testingtable2 LATERAL VIEW explode(purchased_item) exploded_table AS > prod_and_ts where user_id is NOT NULL > ) prod_and_ts > ) tt2 LATERAL VIEW explode(split(timestamps, *\**"#\"*)) exploded_table2 > AS prod_and_ts_split > WHERE to_date(from_unixtime(cast(prod_and_ts_split AS BIGINT))) = > '2012-07-12' > GROUP BY user_id > ,product_id > ,prod_and_ts_split > ORDER BY user_id > ,prod_and_ts_split DESC" > > or > > ... explode(split(timestamps, *'**#'*)) ... > > > Best regards, > Jan > > > On Wed, Aug 8, 2012 at 4:46 AM, Techy Teck <comptechge...@gmail.com>wrote: > >> This is my below HiveQL query that I am running from the shell prompt. >> The only confusion that I am having with this is, If you see double quotes >> before first SELECT in red color, it gets closed on the red color *#. *So >> should I escape the *# *character or it will be running fine like this >> also? >> >> >> >> hive -e *"*SELECT user_id >> ,product_id >> ,prod_and_ts_split >> FROM ( >> SELECT * >> FROM ( >> SELECT user_id >> ,prod_and_ts.product_id AS product_id >> ,prod_and_ts.timestamps AS timestamps >> FROM testingtable2 LATERAL VIEW explode(purchased_item) exploded_table >> AS prod_and_ts where user_id is NOT NULL >> ) prod_and_ts >> ) tt2 LATERAL VIEW explode(split(timestamps, *"#"*)) exploded_table2 AS >> prod_and_ts_split >> WHERE to_date(from_unixtime(cast(prod_and_ts_split AS BIGINT))) = >> '2012-07-12' >> GROUP BY user_id >> ,product_id >> ,prod_and_ts_split >> ORDER BY user_id >> ,prod_and_ts_split DESC" >> > >
