[jira] [Comment Edited] (PHOENIX-3999) Optimize inner joins as SKIP-SCAN-JOIN when possible

2017-08-28 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144780#comment-16144780 ] Maryann Xue edited comment on PHOENIX-3999 at 8/29/17 5:53 AM: --- The reason

[jira] [Commented] (PHOENIX-3999) Optimize inner joins as SKIP-SCAN-JOIN when possible

2017-08-28 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144780#comment-16144780 ] Maryann Xue commented on PHOENIX-3999: -- The reason why hash cache is used in this query is that

[jira] [Created] (PHOENIX-4138) Create a hard limit on number of indexes per table

2017-08-28 Thread Rahul Shrivastava (JIRA)
Rahul Shrivastava created PHOENIX-4138: -- Summary: Create a hard limit on number of indexes per table Key: PHOENIX-4138 URL: https://issues.apache.org/jira/browse/PHOENIX-4138 Project: Phoenix

[jira] [Updated] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ethan Wang updated PHOENIX-418: --- Description: Support an "approximation" of count distinct to prevent having to hold on to all

[jira] [Updated] (PHOENIX-153) Implement TABLESAMPLE clause

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ethan Wang updated PHOENIX-153: --- Description: Support the standard SQL TABLESAMPLE clause by implementing a filter that uses a skip

[jira] [Commented] (PHOENIX-3815) Only disable indexes on which write failures occurred

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144741#comment-16144741 ] James Taylor commented on PHOENIX-3815: --- I think we should just get rid of

[jira] [Commented] (PHOENIX-2460) Implement scrutiny command to validate whether or not an index is in sync with the data table

2017-08-28 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144711#comment-16144711 ] Hudson commented on PHOENIX-2460: - FAILURE: Integrated in Jenkins build Phoenix-master #1754 (See

[jira] [Commented] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144645#comment-16144645 ] Hudson commented on PHOENIX-418: FAILURE: Integrated in Jenkins build Phoenix-master #1753 (See

[jira] [Commented] (PHOENIX-3815) Only disable indexes on which write failures occurred

2017-08-28 Thread Vincent Poon (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144631#comment-16144631 ] Vincent Poon commented on PHOENIX-3815: --- [~jamestaylor] Can you review? Note this requires

[jira] [Updated] (PHOENIX-3815) Only disable indexes on which write failures occurred

2017-08-28 Thread Vincent Poon (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vincent Poon updated PHOENIX-3815: -- Attachment: PHOENIX-3815.v1.patch > Only disable indexes on which write failures occurred >

[jira] [Assigned] (PHOENIX-3815) Only disable indexes on which write failures occurred

2017-08-28 Thread Vincent Poon (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vincent Poon reassigned PHOENIX-3815: - Assignee: Vincent Poon (was: James Taylor) > Only disable indexes on which write

[jira] [Commented] (PHOENIX-4080) The error message for version mismatch is not accurate.

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144550#comment-16144550 ] Ethan Wang commented on PHOENIX-4080: - [~gjacoby] Yes I have re-run the ITs in my local and all

[jira] [Updated] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ethan Wang updated PHOENIX-418: --- Description: Support an "approximation" of count distinct to prevent having to hold on to all

[jira] [Updated] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ethan Wang updated PHOENIX-418: --- Description: Support an "approximation" of count distinct to prevent having to hold on to all

[jira] [Updated] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ethan Wang updated PHOENIX-418: --- Description: Support an "approximation" of count distinct to prevent having to hold on to all

[jira] [Updated] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ethan Wang updated PHOENIX-418: --- Description: Support an "approximation" of count distinct to prevent having to hold on to all

[jira] [Commented] (PHOENIX-3999) Optimize inner joins as SKIP-SCAN-JOIN when possible

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144542#comment-16144542 ] James Taylor commented on PHOENIX-3999: --- bq. only during inner join: ITEMS table as parent will

[jira] [Created] (PHOENIX-4137) Document IndexScrutinyTool

2017-08-28 Thread James Taylor (JIRA)
James Taylor created PHOENIX-4137: - Summary: Document IndexScrutinyTool Key: PHOENIX-4137 URL: https://issues.apache.org/jira/browse/PHOENIX-4137 Project: Phoenix Issue Type: Task

[jira] [Updated] (PHOENIX-4137) Document IndexScrutinyTool

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-4137: -- Fix Version/s: 4.12.0 > Document IndexScrutinyTool > -- > >

[jira] [Updated] (PHOENIX-4136) Document APPROXIMATE_COUNT_DISTINCT function

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-4136: -- Description: Now that PHOENIX-418 has been committed, we need to document this new function

[jira] [Commented] (PHOENIX-4002) Document FETCH NEXT| n ROWS from Cursor

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144494#comment-16144494 ] James Taylor commented on PHOENIX-4002: --- Ping [~gsbiju]. > Document FETCH NEXT| n ROWS from

[jira] [Created] (PHOENIX-4136) Document APPROXIMATE_COUNT_DISTINCT function

2017-08-28 Thread James Taylor (JIRA)
James Taylor created PHOENIX-4136: - Summary: Document APPROXIMATE_COUNT_DISTINCT function Key: PHOENIX-4136 URL: https://issues.apache.org/jira/browse/PHOENIX-4136 Project: Phoenix Issue

[jira] [Resolved] (PHOENIX-2460) Implement scrutiny command to validate whether or not an index is in sync with the data table

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2460. --- Resolution: Fixed Fix Version/s: 4.12.0 Thanks for the contribution, [~vincentpoon].

[jira] [Commented] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144482#comment-16144482 ] James Taylor commented on PHOENIX-418: -- Do you know what the difference are, [~mujtabachohan]

[jira] [Commented] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144459#comment-16144459 ] James Taylor commented on PHOENIX-418: -- Thanks, [~aertoria]. I've pushed your last patch to 4.x and

[jira] [Commented] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144380#comment-16144380 ] Ethan Wang commented on PHOENIX-418: Changes has been made to pom for using 2.9.5. The flaky IT tests

[jira] [Commented] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144378#comment-16144378 ] Hadoop QA commented on PHOENIX-418: --- {color:red}-1 overall{color}. Here are the results of testing the

[jira] [Created] (PHOENIX-4135) CSV Bulk Load get slow in last phase of JOB (after 70% reduce completion)

2017-08-28 Thread Parakram (JIRA)
Parakram created PHOENIX-4135: - Summary: CSV Bulk Load get slow in last phase of JOB (after 70% reduce completion) Key: PHOENIX-4135 URL: https://issues.apache.org/jira/browse/PHOENIX-4135 Project:

[jira] [Updated] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Ethan Wang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ethan Wang updated PHOENIX-418: --- Attachment: PHOENIX-418-v6.patch > Support approximate COUNT DISTINCT >

[jira] [Created] (PHOENIX-4134) Per the changes at Hbase 1.3.1, upgrade ConnectionQueryServiceImpl to use ClusterConnection rather than HConnection

2017-08-28 Thread Ethan Wang (JIRA)
Ethan Wang created PHOENIX-4134: --- Summary: Per the changes at Hbase 1.3.1, upgrade ConnectionQueryServiceImpl to use ClusterConnection rather than HConnection Key: PHOENIX-4134 URL:

[jira] [Commented] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144178#comment-16144178 ] James Taylor commented on PHOENIX-418: -- [~aertoria]. Thanks for the updated patch. Please update the

[jira] [Commented] (PHOENIX-4132) TestIndexWriter causes builds to hang sometimes

2017-08-28 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-4132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144158#comment-16144158 ] James Taylor commented on PHOENIX-4132: --- +1 > TestIndexWriter causes builds to hang sometimes >

[jira] [Updated] (PHOENIX-4133) [hive] ColumnInfo list should be reordered and filtered refer the hive tables

2017-08-28 Thread ZhuQQ (JIRA)
y3,uv:uv" ); {code} Then insert to {{test.test_part}}: {code:sql} INSERT INTO test.test_part SELECT 'some key', 20170828,80; {code} throws error: {code:java} ERROR 203 (22005): Type mismatch. BIGINT cannot be coerced to VARCHAR {code} And insert to {{test.test_uv}}: {code:sql} INSERT INTO test.t

[jira] [Updated] (PHOENIX-4133) [hive] ColumnInfo list should be reordered and filtered refer the hive tables

2017-08-28 Thread ZhuQQ (JIRA)
y3,uv:uv" ); {code} Then insert to {{test.test_part}}: {code:sql} INSERT INTO test.test_part SELECT 'some key', 20170828,80; {code} throws error: {code:java} ERROR 203 (22005): Type mismatch. BIGINT cannot be coerced to VARCHAR {code} And insert to {{test.test_uv}}: {code:sql} INSERT INTO te

[jira] [Created] (PHOENIX-4133) [hive] ColumnInfo list should be reordered and filtered refer the hive tables

2017-08-28 Thread ZhuQQ (JIRA)
ix.zookeeper.client.port" = "2181", "phoenix.rowkeys" = "key1,key2,key3", "phoenix.column.mapping" = "key1:key1,key2:key2,key3:key3,uv:uv" ); {code} Then insert to {{test.test_part}}: {code:sql} INSERT INTO test.test_part SELECT 'some key', 20

[jira] [Commented] (PHOENIX-418) Support approximate COUNT DISTINCT

2017-08-28 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16143482#comment-16143482 ] Hadoop QA commented on PHOENIX-418: --- {color:red}-1 overall{color}. Here are the results of testing the