submit Index populate Job to yarn cluster

Async Index job http://phoenix.apache.org/secondary_indexing.html: ${HBASE_HOME}/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool --schema MY_SCHEMA --data-table MY_TABLE --index-table ASYNC_IDX --output-path ASYNC_IDX_HFILES How to submit that job to a yarn cluster ? On a single

Re: Getting swamped with Phoenix *.tmp files on SELECT.

Was unable to apply the PHOENIX-2556 patch (https://issues.apache.org/jira/secure/attachment/12780561/PHOENIX-2556.patch from https://issues.apache.org/jira/browse/PHOENIX-2556) as suggested.  As I am using a much older version of Phoenix (4.4 vs 4.7) there are quite a few conflicts. Not sure

Extract report from phoenix table

Hi Is there a way using phoenix we can query a huge table to extract some information from them ? The "where" condition will have "value" fields and might not have any row key fields. I am looking for something like a phoenix mapreduce ( https://phoenix.apache.org/phoenix_mr.html) but this

Re: Apache Phoenix + Wildfly (JEE)

Are you aware of the work being done to create shaded jars (PHOENIX-2535)? This would be a good driver for that effort. Thanks, James On Thu, Apr 21, 2016 at 8:43 AM, wrote: > > It would be great if I could get some feedback on my current integration > effort of

Re: Getting swamped with Phoenix *.tmp files on SELECT.

My first suggestion would be to upgrade to the latest version of Phoenix which it doesn't seem like is possible in your case. Second would be to try applying the patch in PHOENIX-2556 and see if that solves the issue for you. If that doesn't work either, please file a JIRA and one of us will take

does secondary index works on view on hbase ?

1. I have hbase table: hbase shell: create 'table', 'cf' 2. then create view on that phoenix: create view "table" (pk varchar primary key, "cf"."field" varchar); 3. create index on view phoenix: create index idx on "table" ("cf"."field"); IDX created in phoenix, and I can select

question about populating async index table

hi, I read from document that index can be created asynchronously. After create index with ASYNC keyword, then kick off a MapReduce Job to pupulate index. ${HBASE_HOME}/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool --schema MY_SCHEMA --data-table MY_TABLE --index-table ASYNC_IDX

Re: Undefined column. columnName=IS_ROW_TIMESTAMP

Arun, the observations you had is understandable. So, that's why we again requested the output of *echo "scan 'SYSTEM.CATALOG',{RAW=>true}"|bin/hbase shell|grep CATALOG* So that we can help you in adding ROW_TIMESTAMP column in system.catalog table so that your phoenix setup works properly and

Re: apache phoenix json api

Hi Francis, Thank you for supporting me ! I appreciate that! Below are the commands i executed and the respective responses. As you will see the new data is missing. And these are the details about my setup: OS: Ubuntu 14.04.3 LTS hbase: Version 1.1.2.2.3.4.0-3485 phoenix: Version