how to create index on column within column family

Hello everyone, I'm using Phoenix-4.8.0 with HBase-0.98, and trying to create index on my table following the link (https://phoenix.apache.org/secondary_indexing.html). create index my_global_index on my_table ("cf".col); OR create local index my_local_index on my_table ("cf".col); The

Re: Ordering of numbers generated by a sequence

JFYI, phoenix.query.rowKeyOrderSaltedTable is deprecated and is not honored from v4.4, so please use phoenix.query.force.rowkeyorder instead. I have updated the docs(http://localhost:8000/tuning.html) now accordingly. On Mon, Oct 17, 2016 at 3:14 AM, Josh Elser wrote: >

Decoding Phoenix DOUBLE columns

Hi I’m trying to access a Phoenix table from Datameer. Datameer can read HBase, but doesn’t support using the Phoenix JDBC driver, as the Phoenix JDBC driver only does a partial implementation of the JDBC standard. To get around this I’m using the Datameer SDK to write a function that will

Re: Decoding Phoenix DOUBLE columns

Correction - the function is meant to DECODE the double columns, not encode them. Sent from my iPhone On Oct 17, 2016, at 2:43 AM, Michael McAllister > wrote: Hi I'm trying to access a Phoenix table from Datameer. Datameer can read

Connecting as a tenant using Phoenix-Spark integration

I've been doing some experimenting trying to get Phoenix-Spark to read/write from a tenant specific view but have had no success. Judging by the docs and from the source code I've looked at I haven't found any options for connecting as the tenant, which is required when interacting with a tenant

Re: cannot drop a table in Phoenix

try add system tablespace. On Tue, 18 Oct 2016 at 12:41 AM Mich Talebzadeh wrote: > Hi, > > I have a table marketDataHbase create on Hbase as seen below: > > [image: Inline images 1] > > > Trying to drop it but it cannot find it > > 0: jdbc:phoenix:rhes564:2181> drop

is deleting from phoenix slower than deleting from from hbase?

is *delete from table* slower than *delete 'table', 'row'*

Row versions

can I add versions of a row and select versions of a row as I can when using hbase alone?

cannot drop a table in Phoenix

Hi, I have a table marketDataHbase create on Hbase as seen below: [image: Inline images 1] Trying to drop it but it cannot find it 0: jdbc:phoenix:rhes564:2181> drop table "marketDataHbase"; Error: ERROR 1012 (42M03): Table undefined. tableName=marketDataHbase (state=42M03,code=1012)

Re: bulk-upsert spark phoenix

Hi Josh, thank for your reply, I'm trying to implement a bulk save to Phoenix with Apache Spark, and the code you linked helped me a lot. I'm now facing an issue with composite primary keys, I cannot find anywhere in the Phoenix code where the row-key is built using the partial phoenix