Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table student1(S_Id int,
- > S_name Varchar(100),
- > Address Struct<a:int, b:String, c:int>,
- > marks Map<String, Int>);
- OK
- Time taken: 0.439 seconds
- hive>
- hive> Describe Student1;
- OK
- s_id int
- s_name varchar(100)
- address struct<a:int,b:string,c:int>
- marks map<string,int>
- Time taken: 0.112 seconds, Fetched: 4 row(s)
- hive> insert into table student1 values(1, 'Afzal', Struct(42, 'nelson Ave' NY, 08309),MAP("MATH", 89));
- FAILED: ParseException line 1:70 mismatched input 'NY' expecting ) near ''nelson Ave'' in function specification
Add Comment
Please, Sign In to add comment