?????? Can query server run with hadoop ha mode??

2016-09-07 Thread zengbaitang
hi F21 , I am sure hbase-site.xml was configured properly , here is my hbase-site.xml (hbase side) : hbase.rootdir hdfs://stage-cluster/hbase hbase.cluster.distributed true hbase.zookeeper.quorum

Re: Can query server run with hadoop ha mode?

2016-09-07 Thread F21
I have a test cluster running HDFS in HA mode with HBase + Phoenix on docker running successfully. Can you check if you have a properly configured hbase-site.xml that is available to your phoenix query server? Make sure hbase.zookeeper.quorum and zookeeper.znode.parent is present. If

Can query server run with hadoop ha mode??

2016-09-07 Thread zengbaitang
I have a hadoop ha cluster and hbase, and have installed phoenix. I try to use query server today , I start the queryserver and then I exec the following command ./sqlline-thin.py http://tnode02:8765 sel.sql the terminal responds the following error , and the stage-cluster is the value of

Re: Full text query in Phoenix

2016-09-07 Thread James Taylor
Hi Cheyenne, Phoenix does not have full text query capability, so the best you can do today is use our regex built-in functions (which won't be particularly performant). Would you mind filing a JIRA with any ideas for how best to expose this functionality? Thanks, James On Wednesday, September 7,

Full text query in Phoenix

2016-09-07 Thread Cheyenne Forbes
I am using phoenix for my platform but I cant do full text queries "SELECT ID, FirstName, Lastname FROM users WHERE MATCH (FirstName, Lastname) AGAINST ('first_name last_name' IN BOOLEAN MODE) AND [Searcher not blocked by user] Regards, Cheyenne

Caused by: org.apache.calcite.avatica.NoSuchStatementException: null

2016-09-07 Thread Dong-iL, Kim
Hi. sporadically NoSuchStatementException occured when i’m using simple upsert. What shall I do? Regards.

View on existing hbase table with dynamic column family

2016-09-07 Thread Florian . Herrmann
Hey Everybody, i've got an existing hbase table with a rowkey consists of two numbers = and a columnfamily which is a date as running number followed by a characte= r e.g. 20160808[c|s|m]. So how can i map the cf via a view or something else? Thanks in advance. Greets Florian Fiducia & GAD