Are you specifying number of reducers for the job not equal to the no. of regions in your table? ... View more

You can use hive storage handler or pig or spark to do that. https://phoenix.apache.org/hive_storage_handler.html https://phoenix.apache.org/pig_integration.html https://phoenix.apache.org/phoenix_spark.html ... View more

can you try adding serialization=PROTOBUF in your connection string. There seems to be property "phoenix.queryserver.serialization mismatch at client and server. jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF ... View more

Make sure that you have updated hbase-site.xml in your sqlline class path to have properties to take effect. ... View more

There seems to be a bug with automatic rebuild code to understand case sensitive table names. can you tell us which version of HDP or phoenix you are using? ... View more

are you running spark job on same cluster or from different cluster? If,it's from different cluster then check if nodes on the cluster have access to lvadcnc06.hk.standardchartered.com ... View more

bq. we are getting null pointer exception, when we try to access the table programmatically, but when we try with hbase console its working, what could be the issue? can you check that your application also has same hbase-site.xml in classpath. bq.when i checked in zkcli get /hbase-secure, the data length is 0 when you do "ls" on your parent znode /hbase-secure by using zkcli, you should see following nodes. if they don't exists ,it means your cluster if formatted or running on different znode.(check all znodes at root by doing "ls /") [zk: localhost:2181(CONNECTED) 1] ls /hbase-secure [meta-region-server, backup-masters, table, draining, region-in-transition, table-lock, running, master, namespace, hbaseid, online-snapshot, replication, splitWAL, recovering-regions, rs, flush-table-proc] ... View more

Can you first check whether your index is active or not. https://community.hortonworks.com/articles/58818/phoenix-index-lifecycle.html ... View more