Hello Sir, Hope you are doing well !
I am PHP developer and I want to fetch the real time data from Hbase and I have read about Apache phoenix which is provide SQL layer on Hbase. So I have decided to use Apache phoenix in my project but how can I get data from phoenix to PHP. I have read artical about Apache Avatica which support json request and response. I have tried to fetch data using json request but only I am getting column data of table not row data. Is it support but avatica or not ? Please find my request and response. *Refer Document* https://calcite.apache.org/avatica *Request Data * $headers[] = 'request: {"request": "prepare","connectionId": "1","sql": "select count(*) from \"users_data\"","maxRowCount": 1}'; *Response Data :* {"response":"executeResults","missingStatement":false,"rpcMetadata":{"response":"rpcMetadata","serverAddress":"c6401.ambari.apache.org:8765"},"results":[{"response":"resultSet","connectionId":"1","statementId":35,"ownStatement":true,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":true,"currency":false,"nullable":0,"signed":false,"displaySize":40,"label":"ROWKEY","columnName":"ROWKEY","schemaName":"","precision":0,"scale":0,"tableName":"users_data","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":true,"currency":false,"nullable":1,"signed":false,"displaySize":40,"label":"firstName","columnName":"firstName","schemaName":"","precision":0,"scale":0,"tableName":"users_data","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"},{"ordinal":2,"autoIncrement":false,"caseSensitive":true,"searchable":true,"currency":false,"nullable":1,"signed":false,"displaySize":40,"label":"lastName","columnName":"lastName","schemaName":"","precision":0,"scale":0,"tableName":"users_data","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"},{"ordinal":3,"autoIncrement":false,"caseSensitive":true,"searchable":true,"currency":false,"nullable":1,"signed":false,"displaySize":40,"label":"gender","columnName":"gender","schemaName":"","precision":0,"scale":0,"tableName":"users_data","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"},{"ordinal":4,"autoIncrement":false,"caseSensitive":true,"searchable":true,"currency":false,"nullable":1,"signed":false,"displaySize":40,"label":"mail","columnName":"mail","schemaName":"","precision":0,"scale":0,"tableName":"users_data","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"},{"ordinal":5,"autoIncrement":false,"caseSensitive":true,"searchable":true,"currency":false,"nullable":1,"signed":false,"displaySize":40,"label":"mobile","columnName":"mobile","schemaName":"","precision":0,"scale":0,"tableName":"users_data","catalogName":"","type":{"type":"scalar","id":12,"name":"VARCHAR","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":null,"parameters":[],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":null},"firstFrame":{"offset":0,"done":true,"rows":[]},"updateCount":-1,"rpcMetadata":{"response":"rpcMetadata","serverAddress":"c6401.ambari.apache.org:8765"}}]} I can only able to see table column data but not row data. Could you suggest me I am using right way to fetch data from Hbase to PHP if yes then could help me where I am doing wrong. Thanks in Advance. Let me know your concerns. Thanks, Jain Hemant
