| clear query|facets|time |
Search criteria: .
Results from 11 to 20 from
66 (0.198s).
|
|
|
Loading phrases to help you refine your search...
|
|
Exit Status for Success and Failure in HiveQL queries - Hive - [mail # user]
|
|
...Does the hive command make use of an exit status for success vs. failure? I am asking this question as I am executing my few HiveQL queries from my Shell Script and If one HiveQL queri...
|
|
|
Author: Raihan Jamal,
2012-08-16, 00:03
|
|
|
Re: how to do random sampling in hive? - Hive - [mail # user]
|
|
...I think you can use here LIMIT- Limit indicates the number of rows to be returned. The rows returned are chosen at random. The following query returns 5 rows from t1 at random. ...
|
|
|
Author: Raihan Jamal,
2012-08-14, 22:23
|
|
|
count(*) vs count(1) in hive - Hive - [mail # dev]
|
|
...Is there any difference between count(*) and count(1) in Hive. And which one should we use in general and why? Given that I am on Hive 0.6 version. *Raihan Jamal*...
|
|
|
Author: Raihan Jamal,
2012-08-14, 21:33
|
|
|
Re: Running the HiveQL from the shell prompt. - Hive - [mail # user]
|
|
...Thanks Jan for the suggestion. *Raihan Jamal* On Tue, Aug 7, 2012 at 10:01 PM, Jan DolinĂ¡r wrote: he es o...
|
|
|
Author: Raihan Jamal,
2012-08-08, 05:47
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # user]
|
|
...Let me try that and I will update on this thread. *Raihan Jamal* On Tue, Aug 7, 2012 at 11:39 AM, Techy Teck wrote e: e: te: ur 10; m T ? om> r...
|
|
|
Author: Raihan Jamal,
2012-08-07, 18:41
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # user]
|
|
...Hi Vijay, Thanks for the suggestion, If upgrading to Hive was under my control then I would have done for sure, but I am working in a company and they are running Hive 0.6 on all...
|
|
|
Author: Raihan Jamal,
2012-08-07, 18:26
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # user]
|
|
...Yes it supports -e option, but in your query what is date? hive -e "CREATE TEMPORARY FUNCTION yesterdaydate AS 'com.example.hive.udf.YesterdayDate'; SELECT * FROM REALTIME where dt=$(*...
|
|
|
Author: Raihan Jamal,
2012-08-07, 18:24
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # user]
|
|
...Hi Jan, I have date in different format also, so that is the reason I was thinking to do by this approach. How can I make sure this will work on the selected partition only and it will...
|
|
|
Author: Raihan Jamal,
2012-08-07, 18:07
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # user]
|
|
...@kulkarni, When I did explain on my query, I got these things, I am not sure how to understand these thing. Any help will be appreciated whether my approach is right or not?- &n...
|
|
|
Author: Raihan Jamal,
2012-08-07, 18:03
|
|
|
Re: Custom UserDefinedFunction in Hive - Hive - [mail # dev]
|
|
...Hi Jan, I figured that out, it is working fine for me now. The only question I have is, if I am doing like this- SELECT * FROM REALTIME where dt= yesterdaydate('yyyyMMdd'...
|
|
|
Author: Raihan Jamal,
2012-08-07, 17:20
|
|
|
|