@MONORANJAN MOHAPATRA, You can use approach suggested by @Slim assuming all the data is of fixed length. You can change it as below hive> CREATE TABLE foo (bar CHAR(11));
hive> insert into foo values ("00-00-8D-AC");
hive> select * from foo;
OK
00-00-8D-AC
Thanks, Aditya
... View more
