Advertisement
Guest User

Untitled

a guest
Mar 26th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. Steve,1 1 1 1 1 5 10 20 10 10 10 10
  2.  
  3. create external table Teller(Name string, Bill array<int>)
  4. row format delimited
  5. fields terminated by ','
  6. Collection items terminated by 't'
  7. stored as textfile
  8. location '/user/training/hive/Teller';
  9.  
  10. load data local inpath'/home/training/hive/input/*.txt' overwrite into table Teller;
  11.  
  12. Steve [null]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement