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/DDL> > http://wiki.apache.org/hadoop/Hive/LanguageManual/DML > > <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
