Re: Paged Queries Not Working

2017-03-27 Thread Bernard Quizon
Thank you James and Rajeshbabu! I will try the row value constructor syntax. On Sat, Mar 25, 2017 at 1:00 AM, James Taylor wrote: > Bernard - the row value constructor syntax will work in the version you're > using and it's a more scalable way of doing paging over HBase

Re: write dataframe to phoenix

2017-03-27 Thread Sateesh Karuturi
Hello Modi, Thanks for the response. i am running the code via spark-submit command, and i have included following jars to spark classpath. still getting exception. hoenix-4.8.0-HBase-1.1-client.jar phoenix-spark-4.8.0-HBase-1.1.jar phoenix-core-4.8.0-HBase-1.1.jar On Mon, Mar 27, 2017 at

Re: write dataframe to phoenix

2017-03-27 Thread Dhaval Modi
Hi Sateesh, If you are running from spark shell, then please include Phoenix spark jar in classpath. Kindly refer to url that Sandeep provide. Regards, Dhaval On Mar 27, 2017 21:20, "Sateesh Karuturi" wrote: Thanks Sandeep for your response. This is the

Re: write dataframe to phoenix

2017-03-27 Thread Sateesh Karuturi
Thanks Sandeep for your response. This is the exception what i am getting: org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 3.0 failed 4 times, most recent failure: Lost task 0.3 in stage 3.0 (TID 411, ip-x-xx-xxx.ap-southeast-1.compute.internal):

Re: write dataframe to phoenix

2017-03-27 Thread Sandeep Nemuri
What is the error you are seeing ? Ref: https://phoenix.apache.org/phoenix_spark.html df.write \ .format("org.apache.phoenix.spark") \ .mode("overwrite") \ .option("table", "TABLE1") \ .option("zkUrl", "localhost:2181") \ .save() On Mon, Mar 27, 2017 at 10:19 AM, Sateesh Karuturi <

Re: how can I cast PhoenixArray to ArrayList

2017-03-27 Thread James Taylor
The JDBC array is not an ArrayList. See http://download.oracle.com/otn_hosted_doc/jdeveloper/905/jdbc-javadoc/oracle/sql/ARRAY.html On Mon, Mar 27, 2017 at 3:50 AM 袁康(基础平台部) wrote: > When I query phoenix in java project > > occur:java.lang.ClassCastException: >

how can I cast PhoenixArray to ArrayList

2017-03-27 Thread 基础平台部
When I query phoenix in java project occur:java.lang.ClassCastException: org.apache.phoenix.schema.types.PhoenixArray cannot be cast to java.util.ArrayList How can I do the transfer?