Problem with Hive fields terminated by -- (hyphen hyphen) I created a manage table like hive> create table jyothi2(id int,name string,sal int) > row format delimited > fields terminated by ‘--’ > stored as textfile; my Input data is 101--mahesh--50000 102--suresh--50023 103--rajesh--70000 104--ramesh--89000 I loaded the data from local it was successfully uploaded into tables but when i tried to retrieve the data from table by using select * from table name the output will come as select * from jyothi1; OK 101 NULL 102 NULL 103 NULL 104 NULL Time taken: 11.226 seconds please help me why it is showing like this and get the the correct output
Posted on: Mon, 27 Jan 2014 05:16:45 +0000
Trending Topics
Recently Viewed Topics
© 2015