Re: Slow query on Secondary Index

2018-09-18 Thread Ankit Singhal
To better understand the problem, we may require your DDL for both the indexes and data table and also the query using your secondary index And, please try some tuning documented on https://phoenix.apache.org/secondary_indexing.html and see if it helps. On Tue, Sep 18, 2018 at 11:25 AM Josh

Re: Read-Write data to/from Phoenix 4.13 or 4.14 with Spark SQL Dataframe 2.1.0

2018-09-18 Thread Josh Elser
Ok, glad to hear you got it working. I don't do any work with the CDH-based releases. Pedro is the primary maintainer of these -- I imagine he's watching this email list. Does the 4.14.0-cdh5.11.2 release not contain a phoenix-spark2 jar? Maybe the explanation is just that the spark2

Re: Slow query on Secondary Index

2018-09-18 Thread Josh Elser
Your question is suitable for the user@phoenix mailing list. Please do not cross post questions to multiple lists. On 9/18/18 10:57 AM, Vishwajeet Rana wrote: Hi, I have two salted global secondary indexes (A and B) on a table with row key (primary key) as the covered column. For both of

Re: Read-Write data to/from Phoenix 4.13 or 4.14 with Spark SQL Dataframe 2.1.0

2018-09-18 Thread lkyaes
sorry for bad copy-paste, versions we have combined together are phoenix-4.14.0-cdh5.11.2-client.jar and phoenix-spark2-4.7.0.2.6.5.3002-10.jar (from last release 4.7.0.2.6.5.3002-10 (17.8.2018)) -worked for us. Br. On Tue, Sep 18, 2018 at 5:26 PM lkyaes wrote: > Hello, thank you for your

Re: Read-Write data to/from Phoenix 4.13 or 4.14 with Spark SQL Dataframe 2.1.0

2018-09-18 Thread lkyaes
Hello, thank you for your response. It gave me a tip :) I've reviewd one more time our JAR's. Before we used - phoenix-4.14.0-cdh5.11.2-client.jar - phoenix-spark-4.14.0-cdh5.11.2.jar Becouse they came together with APACHE_PHOENIX 4.14.0-cdh5.11.2.p0.3* Cloudera parcel* from