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


On Thu, Dec 11, 2014 at 1:03 AM, Gabriel Reid <gabriel.reid@gmail.com> 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



On Mon, Dec 8, 2014 at 7:50 PM, Rama Ramani <rama.ramani@live.com> 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