On Sun, Apr 24, 2011 at 2:34 AM, Erix Yao <[email protected]> wrote: > I mean if I want to export data into local directory using HQL like ' > > INSERT OVERWRITE LOCAL DIRECTORY '/tmp/local_out' SELECT a.* FROM pokes a; > > ' > > How can I change the exported file delimiter, which is ASCII '\001'? > > > > 2011/4/24 bharath vissapragada <[email protected]> >> >> Hi , >> Please see >> http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL >> http://wiki.apache.org/hadoop/Hive/LanguageManual/DML >> These links are pretty good for starters ! >> Thanks >> >> On Sat, Apr 23, 2011 at 10:37 AM, Erix Yao <[email protected]> wrote: >>> >>> As I know, all the data exported from hive use ASCII \001 as the default >>> field delimiter, and I want to change it, How can I achieve this? >>> Thanks >>> >>> -- >>> haitao.yao@Beijing >>> >>> >>> >>> >> >> >> >> -- >> Regards, >> Bharath .V >> w:http://research.iiit.ac.in/~bharath.v > > > > -- > haitao.yao@Beijing > > > > >
No create a table with a format you like then select into it create table xzy as select x, z,y from table row format delimited fields terminated by '\t' Then your files are in /user/hive/warehouse/xzy
