Re: Validate Tuning

Hi Albin, Thank for the fast response :D. Yes it's run and well (i try with phoenix.query.timeoutMs ), but there are other parameter that i doesn't know how to properly test(prove) it. Salam Hormat, Galih Tias R. mardiana On Tue, Sep 22, 2015 at 12:26 PM, Albin Jose wrote: > Hi Galih, > > I h

Re: [DISCUSS] discontinue 4-x HBase 1.0 releases?

Same for us, we are also using CDH5 and it would be a big setback if HBase-1.0 support is stopped by the community. Anirudha On Sat, Sep 19, 2015 at 12:01 PM, James Heather wrote: > We're using CDH5, which runs HBase 1.0. > > I think it would kill the whole Phoenix project for us if there were

Re: Validate Tuning

Hi Galih, I have had the same troubles. I dont think this specific parameter is logged anywhere. But I can guarantee that if you set the parameters (client specific ones) on connection properties it will get picked up by the client jar. If it is sqlline, add them in the hbase-site.xml. - Albin

Validate Tuning

Hii, I wanna know is that posible to retrive data that i have tuning ? (programatic) ex : phoenix.query.queueSize i wanna have valid proof that my tuning are working and valid. fyi. i used java. Thank You Galih Tias R. mardiana

Using Phoenix from Python or Go

Hi everyone, Can Phoenix be used from language that is not based on JVM like Python or Go. If not presently possible, is this planned ? Thanks

Re: AbstractMethodError

Sumit, I tested out HBase 0.98.6 and the Phoenix 4.5.1 server jar and it worked for me. The PhoenixRpcSchedulerFactory.create(Configuration conf, PriorityFunction priorityFunction, Abortable abortable) signature is used for HBase 1.0 and 1.1 versions. The create(Configuration conf, RegionServerSer

Re: Does apache phoenix works with MapRDB aka M7?

Yes, JM is right. It might be more feasible for MapR to implement coprocessors now given the slimmed down and more stable HBase interfaces (as of HBase 1.1). On Mon, Sep 21, 2015 at 9:47 AM, Jean-Marc Spaggiari < jean-m...@spaggiari.org> wrote: > Hi Ashutosh, > > If I'm not mistaken, there is man

Re: Any known issues with Phoenix Schema feature

Hi Vamsi, Phoenix currently only supports the default HBase namespace (see PHOENIX-1966), but as far as I recall, there's been some work (over at Yahoo! I believe) to have a Phoenix schema map to an HBase namespace. Can anyone out there update us on this? Thanks, James On Mon, Sep 21, 2015 at 11

Re: Is there a Pentaho connector for Phoenix

Have you seen this blog post, as it details how to connect Phoenix to Saiku through Pentaho? https://blogs.apache.org/phoenix/entry/olap_with_apache_phoenix_and HTH. Thanks, James On Mon, Sep 21, 2015 at 8:39 AM, kubilay.tsilkara < kubilay.tsilk...@gmail.com> wrote: > I've tried to connect to P

Any known issues with Phoenix Schema feature

Hi, We tried to use HBase namespace feature with Phoenix and we see there is an issue with creating LOCAL Indexes when we use HBase namespace. We are planning on using Phoenix Schema feature in our application. If someone has already tried it and seen any issues with 'schema' feature, could you p

Re: Error: Encountered exception in sub plan [0] execution.

Hi Alberto, Please make sure you have setup your environment correctly according to https://phoenix.apache.org/installation.html. Thanks, Maryann On Mon, Sep 21, 2015 at 12:46 PM, Alberto Gonzalez Mesas < agme...@hotmail.com> wrote: > cause: not found the phoenix client library in HBASE_HOME/l

Insert time or date on hbase from phoenix

I can't put cells with timestamp into hbase. If put a timestamp "10/10/2015 22:34:21" in hbase and i create a view in phoenix, phoenix not recognized the data. ¿Why? EJ. ++ Create and put data into hbase: Hbase> create 'table1', 'c' Hbase> put 'table1', 'row1', 'c:timestamp', '23/09/2015 14

RE: Error: Encountered exception in sub plan [0] execution.

cause: not found the phoenix client library in HBASE_HOME/lib thx!! Date: Fri, 11 Sep 2015 09:10:06 -0400 Subject: Re: Error: Encountered exception in sub plan [0] execution. From: maryann@gmail.com To: user@phoenix.apache.org Hi Alberto, Could you please check in your server log if there's

Re: Does apache phoenix works with MapRDB aka M7?

Hi Ashutosh, If I'm not mistaken, there is many features missing in MapRDB like coprocessors, and Phoenix relays on them. So my guess is that Phoenix will not work on MapRDB. JM 2015-09-21 12:43 GMT-04:00 Ashutosh Sharma : > > please let me know. > -- > With best Regards: > Ashutosh Sharma >

Does apache phoenix works with MapRDB aka M7?

-- With best Regards: Ashutosh Sharma

Does apache phoenix works with MapRDB aka M7?

please let me know. -- With best Regards: Ashutosh Sharma

Re: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.CATALOG

Hi , Since you have just reset HBase, see if the table name 'SYSTEM.CATALOG' exists as a znode in zookeeper path /hbase/tables/ . If so, you can do a rmr from the zookeeper shell. Hope it helps. Regards On Mon, Sep 21, 2015 at 8:48 AM, Konstantinos Kougios < kostas.koug...@googlemail.com> wro

Is there a Pentaho connector for Phoenix

I've tried to connect to Phoenix using Pentaho PDI (aka Kettle) with no success. Pentaho is an ETL tool which can do parallel loads to loads of endpoints, including HBase, Hive etc... using JDBC/ODBC connectors. Is there one for Phoenix? Doe

AbstractMethodError

Hi, I am using Hbase 0.98.6 and Phoenix 4.5.1 and this combination. As per phoenix Jira and some blogs(https://phoenix.apache.org/secondary_indexing.html), these should also be affected by deadlock occurring during index maintenance for global indexes (https://issues.apache.org/jira/browse/PHOEN

Re: setting up community repo of Phoenix for CDH5?

Good stuff! Thank you! James On 21/09/15 14:00, Jean-Marc Spaggiari wrote: Hi James, I have been able to build a parcel and installed it on my own cluster. Build it with 4.5.2 that Andrew modified. I'm in touch with Cloudera to see what's the next steps. I will let you know very shortly...

Re: Issues while running psql.py localhost command

What all phoenix*server*.jar needs to be copied into HBase Lib directory? I think i m missing something on that front...on my ubuntu laptop...the same stuff with the same version is working...but not on my ubuntu laptop...i think i haven't copied the correct JAR file into HBase lib. On Mon, Sep 2

Re: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.CATALOG

in the hbase master log I notice: 2015-09-21 14:45:49,569 WARN [ProcedureExecutorThread-10] procedure.CreateTableProcedure: The table SYSTEM.CATALOG does not exist in meta but has a znode. run hbck to fix inconsistencies. I run hbase hbck -fix but still getting the same error when running

org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.CATALOG

Hi all, I got an installation of hbase-1.1.2 + phoenix-4.5.1. I reset hbase by removing the /hbase folder from hdfs (hadoop fs -rm -r -f /hbase) and restarted hbase. Now hbase works fine but for phoenix I am getting the exception below. I suppose this is due to the system catalog table been rem

Re: setting up community repo of Phoenix for CDH5?

Hi James, I have been able to build a parcel and installed it on my own cluster. Build it with 4.5.2 that Andrew modified. I'm in touch with Cloudera to see what's the next steps. I will let you know very shortly... JM 2015-09-21 6:25 GMT-04:00 James Heather : > @JM how did you get on with the

Re: setting up community repo of Phoenix for CDH5?

@JM how did you get on with the parcel building? Has anyone managed to get 4.5 working on CDH5 now? I was going to stick with 4.3 on our cluster until we had a parcel, but I'm now needing to use pherf, and that doesn't seem to exist in 4.3. James On 16/09/15 12:46, Jean-Marc Spaggiari wrote:

Re: Issues while running psql.py localhost command

@James You can check this https://issues.apache.org/jira/browse/HBASE-10591 for more information. Some sanity checks of table attributes are failing. @Ashutosh you can raise an issue to validate the table attributes which are not meeting minimum criteria or else you can specify them as table pro

Re: Issues while running psql.py localhost command

I don't know for certain what that parameter does but it sounds a bit scary to me... On 21/09/15 09:41, rajeshb...@apache.org wrote: You can try adding below property to hbase-site.xml and restart hbase. hbase.table.sanity.checks false Thanks, Rajeshbabu. On Mon, Sep 21, 2015 at 12:51 PM, A

Re: Issues while running psql.py localhost command

You can try adding below property to hbase-site.xml and restart hbase. hbase.table.sanity.checks false Thanks, Rajeshbabu. On Mon, Sep 21, 2015 at 12:51 PM, Ashutosh Sharma < ashu.sharma.in...@gmail.com> wrote: > I am getting into issues while running phoenix psql.py command against my > local

Issues while running psql.py localhost command

I am getting into issues while running phoenix psql.py command against my local Hbase instance. Local HBase is running perfectly fine. Any help? root@ashu-HP-ENVY-15-Notebook-PC:/phoenix-4.5.2-HBase-1.1-bin/bin# ./psql.py localhost /phoenix-4.5.2-HBase-1.1-src/examples/STOCK_SYMBOL.sql 15/09/21 0