| clear query|facets|time |
Search criteria: .
Results from 1 to 10 from
51 (0.109s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: Rolling MAU computation - Hive - [mail # user]
|
|
...For both simplicity and efficiency, I'd recommend making the mausummary table partitioned on date and generate the MAU data each day. There is no reason to generate MAU data for a given day ...
|
|
|
Author: Vijay,
2012-10-12, 20:42
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # user]
|
|
...You actually don't need hive on the whole cluster. That's the beauty of it. You only need it on the client machine where you're submitting hive jobs. Of course the metadata store does need t...
|
|
|
Author: Vijay,
2012-08-07, 18:31
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # user]
|
|
...Given the implementation of the UDF, I don't think hive would be able to use partition pruning. Especially the version you're using. I'd really recommend upgrading to a later version that ha...
|
|
|
Author: Vijay,
2012-08-07, 18:11
|
|
|
Re: Passing date as command line arguments - Hive - [mail # user]
|
|
...There can't be a space in the variable name. Try this: ${hiveconf:start_date} On Fri, Aug 3, 2012 at 11:06 PM, Techy Teck wrote:...
|
|
|
Author: Vijay,
2012-08-04, 06:32
|
|
|
Re: HBASE and HIVE Integration - Hive - [mail # user]
|
|
... Sent from my iPhone On Jul 25, 2012, at 8:58 PM, vijay shinde wrote: _201207251858_0004 Job: ion hbase and zookeeper as follows: lib/zookeeper-3.4.3.jar:$HADOOP...
|
|
|
Author: Vijay,
2012-07-26, 11:30
|
|
|
Re: Invalid Table Alias - Hive - [mail # user]
|
|
...There seems to be something wrong with the query (the red highlighted portion). What is mi in "abs(datediff(mi"? On Sun, Jul 22, 2012 at 11:28 AM, Techy Teck wrote:...
|
|
|
Author: Vijay,
2012-07-23, 02:02
|
|
|
Re: Exploding Array of Struct in Hive - Hive - [mail # user]
|
|
...You basically need to do a nested-explode here. SELECT user_id, product_id, prod_and_ts_split FROM ( SELECT * FROM (select user_id, prod_and_ts.product_id as product_id, prod_an...
|
|
|
Author: Vijay,
2012-07-19, 00:37
|
|
|
Re: Get only the date from DateType data - Hive - [mail # user]
|
|
...string to_date(string timestamp) does the trick. The official hive UDF page has all the useful functions that are available: https://cwiki.apache.org/confluence/display/Hive/LanguageMa...
|
|
|
Author: Vijay,
2012-07-18, 22:49
|
|
|
Re: Anything wrong with this query? - Hive - [mail # user]
|
|
...When you say LATERAL VIEW explode(purchased_item) exploded_table as prod_and_ts The last alias is an alias to a column; not a table. explode will only produce one column per row; it cannot p...
|
|
|
Author: Vijay,
2012-07-11, 05:33
|
|
|
Re: Invalid Function rank in HiveQL - Hive - [mail # user]
|
|
...In that case, wouldn't this work: SELECT buyer_id, item_id, rank(buyer_id), created_time FROM ( SELECT buyer_id, item_id, created_time FROM testingtable1 &n...
|
|
|
Author: Vijay,
2012-07-10, 23:37
|
|
|
|
