default> create external table test12
> (a text, b text)
> using TEXT with ('text.delimiter'='|')
> location '/home/hadoop/DATA/APPROVAL/test.csv';
OK
default>
default> select * from test12 ;
a, b
-------------------------------
1占쏙옙占쌘듸옙, 占쏙옙占쏙옙占쏙옙占쏙옙
2占쏙옙占쌘듸옙, 占쏙옙占쏙옙占쏙옙占쏙옙
3占쏙옙占쌘듸옙, 占쏙옙占쏙옙占쏙옙占쏙옙
4占쏙옙占쌘듸옙, 占쏙옙占쏙옙占쏙옙占쏙옙
(4 rows, 0.016 sec, 0 B selected)