hiveql - MULTIPLE INSERT OVERWRITE in HIVE -
I am trying to overwrite multiple inserts in the hive by the following commands.
Select the tap, race, faucet, faucet from the result of the INSERT overwrite table, where the field = 'title'; and after the first command, the content of the table of results_3
tap up on crawl creek (2000 digital remasters), nail nail null the weight (2000 digital remasters) Rainfall (LP version) zero zero zero I Alaska zero zero zero to zero zero zero zero against zero zero zero Lyin 'eyes zero zero zero Answer Who will stop zero zero zero zero of zero Rhythm me a ma Nten The narwhal is faucet Knight found out the result of nail tap Invert Owhrrrait table. Select the tap, faucet, race, tap from the result where the field = 'album'; and another order
zero zero the zero zero zero the zero zero zero the Cascades zero zero zero after the Creedence Clearwater results_3 Table of contents revival Zero Zero Zero Johnny Cash Zero Zero Bob Sager Zero Zero Eagles Zero Zero Zero Johnny Horton Zero Zero Zero Marty Robbins Zero Zero Bob Sager Zero But I want to merge two things oneStudent Have you any idea how can I face it?
Thanks
Attached to you like this:
insert overwrite table Select col2 ... to col2 (table --old data union select all col1 ... col2n select col1 from table 2 ... coln - new data)
Comments
Post a Comment