| clear query|facets|time |
Search criteria: .
Results from 31 to 40 from
118 (0.211s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: most efficient way to concatenate 3 tables into one? - Hive - [mail # user]
|
|
...Hi Just follow the steps 1) Create an external table with location as /user/aggregatedTable 2) Move the contents of 3 monthly tables to this location Hadoop fs -cp /user/monthlyTable1/...
|
|
|
Author: Bejoy KS,
2012-09-12, 20:23
|
|
|
Re: most efficient way to concatenate 3 tables into one? - Hive - [mail # user]
|
|
...Hi If all the 3 tables have the same. Schema, Create an external table and move the data from all the 3 tables to this new table's location. Just a hdfs copy or move is not that expens...
|
|
|
Author: Bejoy KS,
2012-09-12, 20:06
|
|
|
Re: How to update and delete a row in hive - Hive - [mail # user]
|
|
...Hi Rams Adding on to Chuck's comments. In hive you can get a work arou nd for updates and deletes only by overwriting a table or atleast a partiti on if table is partitioned. If update...
|
|
|
Author: Bejoy KS,
2012-09-11, 15:23
|
|
|
Re: Where does hive store join query results - Hive - [mail # user]
|
|
...Hi Rajesh If you like to store the results of some hive query in a d irectory you need to use query like INSERT OVERWRITE [LOCAL] DIRECTO RY 'fs location' ' 'https://cwiki....
|
|
|
Author: Bejoy KS,
2012-09-10, 05:13
|
|
|
Re: hive table missing - Hive - [mail # user]
|
|
...Hi Sam Hive table details are on he metastore db and would be gone only if that entry is deleted. That is on a drop command normally. Hive table will be there even if there is no...
|
|
|
Author: Bejoy KS,
2012-09-09, 11:11
|
|
|
Re: FAILED: Error in metadata - Hive - [mail # user]
|
|
...Hi Yogesh It looks like hive is still on the derby db . Can you restar t your hive instances after updating the hive-site.xml. Also please mak e sure that you are modifying the right c...
|
|
|
Author: Bejoy KS,
2012-09-09, 09:21
|
|
|
Re: How to load csv data into HIVE - Hive - [mail # user]
|
|
...Hi Chuck I believe Praveenesh was adding his thought to the discussion on preprocessing the data using mapreduce itself. If you go with hadoop streaming you can use the python script i...
|
|
|
Author: Bejoy KS,
2012-09-08, 12:33
|
|
|
Re: Changing Hive default representation of nulls from \N to something else - Hive - [mail # user]
|
|
...Hi Charles You may need to replace the NULLS with 'NULL' s tring . INSERT OVERWRITE staging_table SELECT ... CASE WHEN clm n_1 IS NULL THEN "NULL" else clmn_1 ... Thank Y...
|
|
|
Author: Bejoy KS,
2012-09-07, 07:06
|
|
|
Re: How to get percentage of each group? - Hive - [mail # user]
|
|
...Hi CROSS JOIN is same as giving JOIN keyword. CROSS JOIN just a new notation in later releases of hive. JOIN without ON is same as CROSS JOIN Regards, Bejoy KS ________...
|
|
|
Author: Bejoy KS,
2012-09-07, 06:59
|
|
|
Re: Unexpected end of input stream - Hive - [mail # user]
|
|
...Hi Kiwon You can get this information from the jobdetails web page itself. Browse to your failed task and there you can see the details on which file/block it had processed and failed ...
|
|
|
Author: Bejoy KS,
2012-08-28, 16:32
|
|
|
|
