Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Running the HiveQL from the shell prompt.


Copy link to this message
-
Re: Running the HiveQL from the shell prompt.
Thanks Jan for the suggestion.

*Raihan Jamal*

On Tue, Aug 7, 2012 at 10:01 PM, Jan Dolinár <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>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"
>>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB