First you can map the table created in HBase to Phoenix with create table query as mentioned in "Mapping to an Existing HBase Table" at phoenix.apache.org and then create view on it. ... View more

@vamsi valiveti bq. 1)what is the meaning of COUNTER VALUE = 23 i can see cf1:no3 is incremented to 3 but i did not what is meant by COUNTER VALUE = 23? COUNTER VALUE printed is latest value after incrementing the value to specified number. In your case the column value before incrementing might be 20. => Hbase::Table - test hbase(main):013:0> incr 'test', 'spam', 'foo:bar', 1 COUNTER VALUE = 1 0 row(s) in 0.0080 seconds hbase(main):014:0> incr 'test', 'spam', 'foo:bar', 1 COUNTER VALUE = 2 0 row(s) in 0.0060 seconds hbase(main):015:0> incr 'test', 'spam', 'foo:bar', 1 COUNTER VALUE = 3 0 row(s) in 0.0040 seconds bq. 2)How to identify no of rows[3 row(s)]?Is it no of distinct keys present in HBASE table? Yes. It's distinct row keys in the table. bq. 3)The below command is showing following error.can not we use incr on existing column in HBASE? Yes we cannot use incr on existing column. The column value should be initialized with incr only. ... View more

The class is from hbase-server.jar. You can add /usr/hdp/2.4.0.0-169/phoenix/lib/hbase-server.jar to classpath and try. ... View more

CREATE TABLE ddl statement automatically creates HBase table. http://phoenix.apache.org/language/index.html#create_table Similary DROP and ALTER TABLE statements drop, alter HBase tables. Here is the full list of queries supported by Phoenix. http://phoenix.apache.org/language/index.html ... View more

@mayki wogno There is a chance that the master might be went down while creating the znode or system catalog table data might be deleted from hdfs You can connect to zookeeper and remove the znode from zookeeper and create connection. The znode path is {zookeeper.znode.parent}/table/SYSTEM.CATALOG. Connect to zookeeper with this command ./hbase zkcli Remove znode from zk client: rmr /hbase-unsecure/table/SYSTEM.CATLOG ... View more