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

Maybe running a program to modify your CSV file to replace any SEMICOLON with COMMA shall be more convinient. From: arthur.hk.c...@gmail.com Date: 2014-10-09 11:26 To: user CC: arthur.hk.c...@gmail.com Subject: How to change default field delimiter from COMMA to SEMICOLON Hi, My CSV fil

Re: Getting InsufficientMemoryException

Modifying phoenix.coprocessor.maxServerCacheTimeToLiveMs parameter which defaults to *30,000 *solved the problem. *Thanks !!* On Wed, Oct 8, 2014 at 10:25 AM, G.S.Vijay Raajaa wrote: > Hi Maryann, > > Its the same query: > > *select c.c_first_name, ca.ca_city, cd.cd_education_s

How to change default field delimiter from COMMA to SEMICOLON

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

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

To exit sqlline you press ctrl-d On Oct 8, 2014 8:26 PM, "arthur.hk.c...@gmail.com" wrote: > 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

回复： issue in like expression in which contains Chinese characters

The version is 4.1.0 Thanks for your reply -- Email: wuyang...@qq.com -- 原始邮件 -- 发件人: "James Taylor";; 发送时间: 2014年10月8日(星期三) 晚上11:44 收件人: "user@phoenix.apache.org"; 主题: Re: issue in like expression in which contains Chinese characters

WARN impl.MetricsConfig: Cannot locate configuration

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

Hi, I have managed to resolve the issue. Regards Arthur On 9 Oct, 2014, at 7:34 am, arthur.hk.c...@gmail.com 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 configuration of Phoenix? > > rega

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

Hi, Arthur Generally the following warnings may not affect your normal usage of phoenix sqlline. But if your really want to avoid such warnings, you may try: 1. For the warning of "Unable to load native-hadoop library for your platform", try add the following script to include native hadoop lib

Re: Re: count on large table

Squirrel sql client possibly connect to host server if your phoenix and hbase are distributed deployed. So I consider it working to configure your phoenix server via modifying hbase-site.xml and reconnect phoenix through squirrel. Thanks, Sun From: Abe Weinograd Date: 2014-10-09 00:15 To

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

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

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 configuration of Phoenix? regards Arthur and include the port number in the JDBC connector string: jdbc:phoenix [ : [: ] [ :/hbase ]] On 8 Oct, 2014, at 9:28

alter column type

is it possible to change column type without dropping it (with DROP COLUMN) and creating a new

Re: count on large table

Good point. I have to figure out how to do that in a SQL Tool like Squirrel or workbench. Is there any obvious thing i can do to help tune this? I know that's a loaded question. My client scanner batches are 1000 (also tried 1 with no luck). Thanks, Abe On Tue, Oct 7, 2014 at 9:09 PM, su.

Re: issue in like expression in which contains Chinese characters

That's a bug - please file a JIRA. What version of Phoenix are you using? Thanks, James On Wednesday, October 8, 2014, wuyang wrote: > Hi, > > When I use like expression in SELECT query. It works well when I put > Chinese characters in LIKE expression on NONE PRIMARY KEY columns . BUT > when I p

Re: Error: Malformed connection url

Hi arthur, its not related to hdfs or hbase path. U need to specify the zookeper quorum jdbc:phoenix [ : [ : ] [ : ] ] -Yeshwanth Can you Imagine what I would do if I could do all I can - Art of War On Wed, Oct 8, 2014 at 5:42 PM, arthur.hk.c...@gmail.com < arthur.hk.c...@gmail.com> wrote: >

Error: Malformed connection url

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

issue in like expression in which contains Chinese characters

Hi, When I use like expression in SELECT query. It works well when I put Chinese characters in LIKE expression on NONE PRIMARY KEY columns . BUT when I put them in LIKE expression on PRIMARY KEY , it occurs an Exception:‍ ‍ select * from "test3" where PK like '中%'; ‍ org.apache.phoenix.sch