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

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

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

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

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

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

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); }

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,

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

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' ,

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

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