Re: How to change default field delimiter from COMMA to SEMICOLON

2014-10-09 Thread arthur.hk.c...@gmail.com
haracter has a special meaning in most shells. Wrapping it with > single quotes should resolve the issue, as follows: > > ./psql.py z1:/hbase -t NATION ../sample/NATION.csv -d ';' > > > - Gabriel > > > On Thu, Oct 9, 2014 at 5:26 AM, arthur.hk.c...@

SALT_BUCKETS

2014-10-09 Thread arthur.hk.c...@gmail.com
Hi, I plan to use Phoenix to load in a very large transaction detail table (about 1TB), my HBASE cluster has 5 nodes, I plan to create a SALTED TABLE for it. 2 questions: Q1) Can anyone suggest how to determine the proper value for SALT_BUCKETS? Q2) In my case here, if I set SALT_BUCKETS = 5

Re: How to change default field delimiter from COMMA to SEMICOLON

2014-10-09 Thread arthur.hk.c...@gmail.com
LON with > COMMA shall be more convinient. > > > > From: [email protected] > Date: 2014-10-09 11:26 > To: user > CC: [email protected] > Subject: How to change default field delimiter from COMMA to SEMICOLON > Hi, > > My CSV file uses semicolo

How to change default field delimiter from COMMA to SEMICOLON

2014-10-08 Thread arthur.hk.c...@gmail.com
Hi, My CSV file uses semicolon as field delimiter, I tried to use -d ; but failed. 1) without -d parameter ./psql.py z1:/hbase -t NATION ../sample/NATION.csv 14/10/09 11:14:21 ERROR util.CSVCommonsLoader: Error upserting record [19;"SAUDI ARABIA";4;"fluffy close warthogs into the fluffy gif

WARN impl.MetricsConfig: Cannot locate configuration

2014-10-08 Thread arthur.hk.c...@gmail.com
Hi, I am trying Phoenix Performance test script There are 4 warnings 1) WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties Question: How to resolve it? 2) WARN util.DynamicClassLoader: Failed to identify the fs of dir hdfs

Re: Error: Malformed connection url

2014-10-08 Thread arthur.hk.c...@gmail.com
Hi, I have managed to resolve the issue. Regards Arthur On 9 Oct, 2014, at 7:34 am, [email protected] wrote: > Hi, > > Thank you so much! > > I am new to phoenix, could you advice where to set the JDBC connector string > in Phoenix? is it in some config

WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform

2014-10-08 Thread arthur.hk.c...@gmail.com
Hi, I have two questions: Q1: When trying sqlline, I got the following warning message, please advise how to resolve it? Q2: How to exit sqlline command shell? I tried “exit;” and “quit;” but no luck. I am using Hadoop 2.4.1 with HA and Hbase 0.98.6. regards Arthur ./sqlline.py z1:/hbase Se

Re: Error: Malformed connection url

2014-10-08 Thread arthur.hk.c...@gmail.com
t; > On Wed, Oct 8, 2014 at 5:42 PM, [email protected] > wrote: > Hi, > > I use Hadoop 2.4.1 Cluster and HBase Cluster (0.98.6), my HBASE rootdir is > hdfs://my_cluster/hbase > > hbase-site.xml > > hbase.rootdir > hdfs://my_cluster/hbase > > &

Error: Malformed connection url

2014-10-08 Thread arthur.hk.c...@gmail.com
Hi, I use Hadoop 2.4.1 Cluster and HBase Cluster (0.98.6), my HBASE rootdir is hdfs://my_cluster/hbase hbase-site.xml hbase.rootdir hdfs://my_cluster/hbase hdfs-site.xml dfs.nameservices my_cluster true The hbase shell works well, when I tired Phoenix I got t