Cant run map-reduce index builder because my view/idx is lower case

Hello, Im trying to build ASYNC index by example from https://phoenix.apache.org/secondary_indexing.html My issues is that my view name and index name is lower case, so map-reduce rise error: 2017-06-17 03:45:56,506 ERROR [main] index.IndexT

Re: Phoenix Upgrade compatibility

Updating my question here: I found some info from a post on May 19th under (Upgrade Phoenix version on HDP 2.4). It seems for those using HDP 2.6, we are stuck with Phoenix 4.7 until the next Hortonworks release. :( To any Hortonworks people out there: Is there any way we could do a full install

Phoenix Upgrade compatibility

According to https://phoenix.apache.org/upgrading.html "Phoenix maintains backward compatibility across at least two minor releases to allow for *no downtime* through server-side rolling restarts upon upgrading. See below for details" We would like to upgrade from version 4.7 to a newer version.

Create View of Existing HBase table

*I have an existing HBase table with the following characteristics:* hbase(main):032:0> describe 'bro' Table bro is ENABLED bro, {TABLE_ATTRIBUTES => {coprocessor$1 => '|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|', coprocessor$2 => '|org.apache.phoenix.coprocessor.UngroupedAg

Getting too many open files during table scan

We are running a 13-node hbase cluster. One table uses 78 SALT BUCKETS which seems to work reasonable well for both read and write. This table has 130 columns with a PK having 30 columns (fairly wide table). However, after adding several new tables we are seeing errors about too many open files

Re: Best strategy for UPSERT SELECT in large table

Hi Pedro, Before 4.10, it will be single client (though multi threaded). With 4.10 and above, the statement would run distributed across your cluster so performance should improve. Note that if the source table is taking writes while the UPSERT SELECT is running, the statement would miss those writ

Best strategy for UPSERT SELECT in large table

Hi guys, We are trying to populate a Phoenix table based on a 1:1 projection of another table with around 15.000.000.000 records via an UPSERT SELECT in phoenix client. We've noticed a very poor performance ( I suspect the client is using a single-threaded approach ) and lots of issues with client

?????? how to modify column in phoenix?

ok,Thanks -- -- ??: "rafa";; : 2017??6??16??(??) 4:39 ??: "user"; : Re: how to modify column in phoenix? Hi, As far as I know there is no support for that in Phoenix. James Taylor explained an alternative to accompli

Re: how to modify column in phoenix?

Hi, As far as I know there is no support for that in Phoenix. James Taylor explained an alternative to accomplish that in this thread: https://mail-archives.apache.org/mod_mbox/phoenix-user/201610.mbox/browser Regards, rafa On Fri, Jun 16, 2017 at 10:33 AM, 曾柏棠 wrote: > hi, >I want to e

how to modify column in phoenix?

hi, I want to expand one column in my phoenix table, but I can not find any words about how to modify column in phoenix reference, so Is phoenix can do something like alter table modify some_column varchar(100)? thanks!