I trying to load csv file into phoenix,I'm getting below error. Error: ERROR client.ConnectionManager$HConnectionImplementation: The node /hbase is not in ZooKeeper. It should have been written by the master. Check the value configured in 'zookeeper.znode.parent'. There could be a mismatch with the one configured in the master. I'm using of below command in console else any alternative command on console please suggest me. hadoop jar /usr/hdp/2.4.2.0-258/phoenix/phoenix-4.4.0.2.4.2.0-258-client.jar org.apache.phoenix.mapreduce.CsvBulkLoadTool --view UDM_TRANS --input /home/hadoop1/sample.csv ... View more

Hi, I am to trying to do offset in phoenix and find that offset support the version 4.4.8, but current version is 4.4.1. Is there any possibility to perform offset or pagination in phoenix for version 4.4.1 code: SELECT Name, Age, DOJ, Salary, Country, State FROM PersonalDetails WHERE COUNTRY IN('IND') ORDER BY DOJ DESC LIMIT 100 OFFSET 2; Error: Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column 58 (state=42P00,code=602) org.apache.phoenix.exception.PhoenixParserException: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column58 Thanks Mohan ... View more