| clear query|facets|time |
Search criteria: .
Results from 91 to 100 from
118 (0.332s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: date datatype in hive - Hive - [mail # user]
|
|
...Hi Soham Rewrite your query with the columns in Group By included in Select as well. Something like select country,name from users_info group by country; Regards Bejo...
|
|
|
Author: Bejoy KS,
2012-06-27, 06:32
|
|
|
Re: hi all - Hive - [mail # user]
|
|
...Hi Shaik On a first look, since you are using Dynamic Partition Insert, the partition column should be the last column on select query used in Insert Overwrite. Modify you...
|
|
|
Author: Bejoy KS,
2012-06-26, 08:14
|
|
|
Re: querying with datetime in hive and mysql - Hive - [mail # user]
|
|
...Hi soham Since the date is stored as String in hive you can use the date functions to get the hour. Just check whether the hour falls in between 10 and 11 AM In simple ter...
|
|
|
Author: Bejoy KS,
2012-06-25, 08:00
|
|
|
Re: Define field delimiters for output files - Hive - [mail # user]
|
|
...Yes, external Tables are no different that managed tables. The main difference in case of external tables is, if you drop a managed table the data in hdfs is also deleted where as in c...
|
|
|
Author: Bejoy KS,
2012-06-19, 08:02
|
|
|
Re: Define field delimiters for output files - Hive - [mail # user]
|
|
...Hi Tishan AFAIK there is no way to specify the delimiter in INSERT OVERWRITE command. The delimiter could be specified on table creation only. You can get your requirement done ...
|
|
|
Author: Bejoy KS,
2012-06-19, 07:05
|
|
|
Re: sqoop, hive and lzo and cdh3u3 - not creating in index automatically - Hive - [mail # user]
|
|
...Hi Chalcy When you create a table you do specify the format of how the data is stored in hdfs. This value can be determined using , describe extended or describe formatted at any later...
|
|
|
Author: Bejoy KS,
2012-06-19, 06:59
|
|
|
Re: sqoop, hive and lzo and cdh3u3 - not creating in index automatically - Hive - [mail # user]
|
|
...Hi Chalcy Lzo indexing not working, Is Lzo codec class available in 'io.compression.codec' property in core-site.xml? Snappy is not splittable on its own. But sequence files are ...
|
|
|
Author: Bejoy KS,
2012-06-18, 14:38
|
|
|
Re: sqoop, hive and lzo and cdh3u3 - not creating in index automatically - Hive - [mail # user]
|
|
...Hi Chalcy Did you notice any warnings related to lzo codec on your mapreduce task logs or on sqoop logs? It could be because LZO libs are not available on the TaskTracker nodes....
|
|
|
Author: Bejoy KS,
2012-06-18, 14:03
|
|
|
Re: Quering RDBMS table in a Hive query - Hive - [mail # user]
|
|
...Hi Ruslan The solution Esteban pointed out was 1. Import look up data from RDBMS to hdfs/hive (you can fire any adhoc query here). If the data is just a few mbs one or two maps/connect...
|
|
|
Author: Bejoy KS,
2012-06-16, 02:04
|
|
|
Re: joining user sessions - Hive - [mail # user]
|
|
...Yes, the framework takes care of this. Regards Bejoy KS Sent from handheld, please excuse typos. From: Cam Bazz Date: Wed, 13 Jun 2012 20:09:12 To: ; Repl...
|
|
|
Author: Bejoy KS,
2012-06-13, 17:10
|
|
|
|
