Re: Read only user permissions to Phoenix table - Phoenix 4.5

why “RXC” is needed the minimum? 在 2017年2月17日，09:15，Sergey Soldatov mailto:sergeysolda...@gmail.com>> 写道： Unfortunately some versions of Phoenix client is using HBase API (such as getHTableDescriptor) that requires HBase CREATE/ADMIN permissions on system tables. Moreover the upgrade path is t

Re: Read only user permissions to Phoenix table - Phoenix 4.5

Unfortunately some versions of Phoenix client is using HBase API (such as getHTableDescriptor) that requires HBase CREATE/ADMIN permissions on system tables. Moreover the upgrade path is trying to create system tables to check whether system requires an upgrade and that may fail with permission exc

Re: Still having issues

If you are using CDH, Phoenix has to be patched to work with Cloudera's HBase derivative. You might try https://github.com/ chiastic-security/phoenix-for-cloudera/tree/4.9-HBase-1.2-cdh5.9 Check out this

Re:

Phoenix has to be patched to work with Cloudera's HBase derivative. You might try https://github.com/chiastic-security/phoenix-for-cloudera/tree/4.9-HBase-1.2-cdh5.9 Check out this tree and build. The procedure for building is the same (https://phoenix.apache.org/building.html) This will pick u

Re:

Are you maybe using a HBase distribution from a vendor? I had similar errors when trying to use Phoenix 4.9 on the Cloudera build of HBase. On 2017-02-16 10:46 (+0100), "Nimrod Oren" wrote: > I didn't mean to sound rude. > > I created another table using phoenix-sqlline according to the docume

Re: Still having issues

It still seems that Spark is unable to find all of the Phoenix/HBase classes that are necessary. As a reference, I've got a Docker image that might help: https://github.com/jmahonin/docker-phoenix/tree/phoenix_spark The versions of Phoenix and Spark it uses are a bit out of date, but it shows th

Re:

Sorry for my tone, I didn’t mean that. I use Phoenix4.9 on HBase1.2, and according to your err info, I looked up HTableDescriptor definition and found this method public HTableDescriptor setValue(String key, String value) { if(value == null) { this.remove(key); } e

Re: Issues with phoenix-spark connector

Yup, that worked, thanks. On Thu, Feb 16, 2017 at 3:01 PM, Sudhir Babu Pothineni wrote: > Phoenix will look for uppercase table name of HBase if not mentioned in > quotes, can you try "\"test\"" > > > > Sent from my iPhone > >> On Feb 16, 2017, at 7:50 AM, Marcin Januszkiewicz >> wrote: >> >>

Re: Protobuf serialized column

Thank you Sent from my iPhone > On Feb 15, 2017, at 11:29 AM, Josh Elser wrote: > > No, PQS is just a proxy to the Phoenix (thick) JDBC driver. > > You are still limited to the capabilities of the Phoenix JDBC driver. You > might be able to do something with a custom UDF, but I'm not sure. >

Re: Issues with phoenix-spark connector

Phoenix will look for uppercase table name of HBase if not mentioned in quotes, can you try "\"test\"" Sent from my iPhone > On Feb 16, 2017, at 7:50 AM, Marcin Januszkiewicz > wrote: > > Hi, > > I'm having some issues with the phoenix spark connector. I'm using the > phoenix-for-cloudera[

Issues with phoenix-spark connector

Hi, I'm having some issues with the phoenix spark connector. I'm using the phoenix-for-cloudera[1] build so I'm not really sure if these are bugs that have been fixed already. 1. I can't use the connector to load tables that have lowercase names. Suppose I have a view of a HBase table called 'tes

Read only user permissions to Phoenix table - Phoenix 4.5

Hi all, I have a quick question. We are still running on Phoenix 4.5 (I know, it's not my fault) and we're trying to setup a read only user on a phoenix table. The minimum set of permissions to get access through sqlline is grant 'readonlyuser' , 'RXC', 'SYSTEM.CATALOG' grant 'readonlyuser' , 'RX

[no subject]

I didn't mean to sound rude. I created another table using phoenix-sqlline according to the documentation: CREATE TABLE IF NOT EXISTS TEST_SAVE_NEW ( IMEI VARCHAR NOT NULL PRIMARY KEY, END_LATITUDE VARCHAR); Still getting the same issue.

Re: Still having issues

Please check whether your table is created by Phoenix( means this table is not a *Mapping* ) , you can follow the sample on phoenix official site, only need *change the version to the latest*, use *phoenix-client* instead, and promise *Schema Corresponding*. Create a new table to test, use simple d

Still having issues

Hi, Even after adding phoenix-spark and phoenix-client I keep missing other methods. Now it's HBase methods: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.HTableDescriptor.setValue(Ljava/lang/String;Ljava/lang/String;)Lorg/apache/hadoop/hbase/HTableDescriptor Isn't there a way for a beg