Re: ROW_TIMESTAMP weird behaviour

2017-03-20 Thread NaHeon Kim
Hi, Does ‘phoenix.query.dateFormatTimeZone’ work as expected? Though dateFormatTimeZone option and HBase servers are set to UTC+9 timezone, UTC+9 based timestamp values are still hidden. What I expect is that those values are available immediately right after upsert. phoenix-4.8.0-HBase-1.1 is

Re: write Dataframe to phoenix

2017-03-20 Thread Sateesh Karuturi
Thanks for response NaHeon.., i added phoenix-spark jar in pom.xml and i am able to read data from phoenix. The problem is getting exception while writing Dataframe to phoenix. On Mon, Mar 20, 2017 at 1:23 PM, NaHeon Kim wrote: > Did you check your project has

Re: write Dataframe to phoenix

2017-03-20 Thread NaHeon Kim
Did you check your project has dependency on phoenix-spark jar? : ) See Spark setup at http://phoenix.apache.org/phoenix_spark.html Regards, NaHeon 2017-03-20 15:31 GMT+09:00 Sateesh Karuturi : > > I am trying to write Dataframe to Phoenix. > > Here is my code: > >

Re: Cannot connect Phoenix to HBase in secure cluster (Kerberos)

2017-03-20 Thread rohitrk.10
Hi, We did not find any other logs. We have added "-Dsun.security.krb5.debug=true", even then there is no much information about the error. And also there are no logs about Phoenix trying to perform kerberos authentication in HBase logs as well as in Kerberos logs. The log shared in the

write Dataframe to phoenix

2017-03-20 Thread Sateesh Karuturi
I am trying to write Dataframe to Phoenix. Here is my code: 1. df.write.format("org.apache.phoenix.spark").mode(SaveMode.Overwrite). options(collection.immutable.Map( 2. "zkUrl" -> "localhost:2181/hbase-unsecure", 3. "table" -> "TEST")).save(); and i am getting following exception: