I just discovered how to get this working properly (I had wrongly assumed that simply supplying '\t' was sufficient).
In order to supply a tab character as the delimiter, you need to supply a tab literal for the -d parameter. This is done (at least on Linux and Mac OS X) by typing Ctrl-v and then hitting the tab character when you're between the single quotes. So in other words, while typing out the command line, the sequence of keystrokes you need to type after the -d flag is: 1. single quote key 2. Ctrl and v keys together 3. Tab key 4. single quote key This is a general terminal thing, and not specific to Phoenix or Java or Python. I don't know if this will work on Windows (and I expect that it won't), and unfortunately I can't say what the correct way is to get something like this working in Windows. - Gabriel On Thu, Dec 11, 2014 at 9:17 AM, Dastagiri Shaik <[email protected]> wrote: > hi , > i am also facing similar type problem > > 1) this is the command > psql.py -t tablename -d '\t' hostname /home/hadoop/staging/ord_smry.csv > > 2) OS is cent os > > 3)Error : > > > Exception in thread "main" java.lang.IllegalArgumentException: Invalid > single character: '\t' > at > org.apache.phoenix.util.PhoenixRuntime$ExecutionCommand.getCharacter(PhoenixRuntime.java:527) > at > org.apache.phoenix.util.PhoenixRuntime$ExecutionCommand.parseArgs(PhoenixRuntime.java:485) > at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:153) > > Version of Phoenix is 4.1 > > Regards > Dastagiri > > On Thu, Dec 11, 2014 at 1:03 AM, Gabriel Reid <[email protected]> > wrote: >> >> Hi Rama, >> >> Could you give a bit more information, including: >> * what is the exact full command that you're entering >> * which version of Phoenix are you using >> * what is your environment (i.e. which OS are you running on) >> * what is the exact error (and/or stacktrace) that you're getting >> >> Thanks, >> >> Gabriel >> >> >> On Mon, Dec 8, 2014 at 7:50 PM, Rama Ramani <[email protected]> wrote: >> > Hello, I have an TSV (tab separated file) and trying to use the -d >> > option >> > with psql.py. >> > >> > I tried specifying '\t' but get an error. How should I specify the tab >> > separator when using psql.py? >> > >> > thanks >> > Rama > >
