Guest User

Untitled

a guest
Apr 26th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. create table student1(S_Id int,
  2. > S_name Varchar(100),
  3. > Address Struct<a:int, b:String, c:int>,
  4. > marks Map<String, Int>);
  5.  
  6. OK
  7. Time taken: 0.439 seconds
  8. hive>
  9.  
  10. hive> Describe Student1;
  11. OK
  12. s_id int
  13. s_name varchar(100)
  14. address struct<a:int,b:string,c:int>
  15. marks map<string,int>
  16. Time taken: 0.112 seconds, Fetched: 4 row(s)
  17.  
  18. hive> insert into table student1 values(1, 'Afzal', Struct(42, 'nelson Ave' NY, 08309),MAP("MATH", 89));
  19.  
  20. FAILED: ParseException line 1:70 mismatched input 'NY' expecting ) near ''nelson Ave'' in function specification
Add Comment
Please, Sign In to add comment