[jira] [Updated] (PHOENIX-5166) DELETE didn't work on phoenix

2019-02-25 Thread Yuan Yifan (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuan Yifan updated PHOENIX-5166:

Attachment: image-2019-02-26-15-36-08-649.png

> DELETE didn't work on phoenix
> -
>
> Key: PHOENIX-5166
> URL: https://issues.apache.org/jira/browse/PHOENIX-5166
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.14.1
> Environment: Apache HBase 1.4
> Phoenix 4.14.1
>Reporter: Yuan Yifan
>Priority: Major
> Fix For: 4.15.0
>
> Attachments: image-2019-02-26-13-56-44-201.png, 
> image-2019-02-26-14-34-50-580.png, image-2019-02-26-15-35-53-229.png, 
> image-2019-02-26-15-36-08-649.png, image-2019-02-26-15-36-47-364.png
>
>
> I executed an SQL that delete some data in table T_LOCATION, the data 
> decreased.
> But there're still 256 rows of data which I can't delete them however I run 
> DELETE repeatedly.
> !image-2019-02-26-13-56-44-201.png!
>  
> I'm preparing to fix it but I don't know where the code should I debug, is 
> there any document of the structure/design of Phoenix?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5166) DELETE didn't work on phoenix

2019-02-25 Thread Yuan Yifan (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuan Yifan updated PHOENIX-5166:

Attachment: image-2019-02-26-15-36-47-364.png

> DELETE didn't work on phoenix
> -
>
> Key: PHOENIX-5166
> URL: https://issues.apache.org/jira/browse/PHOENIX-5166
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.14.1
> Environment: Apache HBase 1.4
> Phoenix 4.14.1
>Reporter: Yuan Yifan
>Priority: Major
> Fix For: 4.15.0
>
> Attachments: image-2019-02-26-13-56-44-201.png, 
> image-2019-02-26-14-34-50-580.png, image-2019-02-26-15-35-53-229.png, 
> image-2019-02-26-15-36-08-649.png, image-2019-02-26-15-36-47-364.png
>
>
> I executed an SQL that delete some data in table T_LOCATION, the data 
> decreased.
> But there're still 256 rows of data which I can't delete them however I run 
> DELETE repeatedly.
> !image-2019-02-26-13-56-44-201.png!
>  
> I'm preparing to fix it but I don't know where the code should I debug, is 
> there any document of the structure/design of Phoenix?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5166) DELETE didn't work on phoenix

2019-02-25 Thread Yuan Yifan (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuan Yifan updated PHOENIX-5166:

Attachment: image-2019-02-26-15-35-53-229.png

> DELETE didn't work on phoenix
> -
>
> Key: PHOENIX-5166
> URL: https://issues.apache.org/jira/browse/PHOENIX-5166
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.14.1
> Environment: Apache HBase 1.4
> Phoenix 4.14.1
>Reporter: Yuan Yifan
>Priority: Major
> Fix For: 4.15.0
>
> Attachments: image-2019-02-26-13-56-44-201.png, 
> image-2019-02-26-14-34-50-580.png, image-2019-02-26-15-35-53-229.png
>
>
> I executed an SQL that delete some data in table T_LOCATION, the data 
> decreased.
> But there're still 256 rows of data which I can't delete them however I run 
> DELETE repeatedly.
> !image-2019-02-26-13-56-44-201.png!
>  
> I'm preparing to fix it but I don't know where the code should I debug, is 
> there any document of the structure/design of Phoenix?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5140) TableNotFoundException occurs when we create local asynchronous index

2019-02-25 Thread MariaCarrie (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

MariaCarrie updated PHOENIX-5140:
-
Description: 
First I create the table and insert the data:

^create table DMP.DMP_INDEX_TEST2 (id varchar not null primary key,name 
varchar,age varchar);^
^upsert into DMP.DMP_INDEX_TEST2 values('id01','name01','age01');^

The asynchronous index is then created:

^create local index if not exists TMP_INDEX_DMP_TEST2 on DMP.DMP_INDEX_TEST2 
(name) ASYNC;^

Because kerberos is enabled,So I need kinit HBase principal first,Then execute 
the following command:

^HADOOP_CLASSPATH="/etc/hbase/conf" hadoop jar 
/usr/hdp/3.0.0.0-1634/phoenix/phoenix-client.jar 
org.apache.phoenix.mapreduce.index.IndexTool --schema DMP --data-table 
DMP_INDEX_TEST2 --index-table TMP_INDEX_DMP_TEST2 --output-path /hbase-backup2^

But I got the following error:

^Error: java.lang.RuntimeException: 
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table 
undefined. tableName=DMP.DMP_INDEX_TEST2^
^at 
org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:124)^
^at 
org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:50)^
^at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146)^
^at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:799)^
^at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347)^
^at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174)^
^at java.security.AccessController.doPrivileged(Native Method)^
^at javax.security.auth.Subject.doAs(Subject.java:422)^
^at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1688)^
^at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168)^
^Caused by: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 
(42M03): Table undefined. tableName=DMP.DMP_INDEX_TEST2^
^at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.getTableRegionLocation(ConnectionQueryServicesImpl.java:4544)^
^at 
org.apache.phoenix.query.DelegateConnectionQueryServices.getTableRegionLocation(DelegateConnectionQueryServices.java:312)^
^at 
org.apache.phoenix.compile.UpsertCompiler.setValues(UpsertCompiler.java:163)^
^at 
org.apache.phoenix.compile.UpsertCompiler.access$500(UpsertCompiler.java:118)^
^at 
org.apache.phoenix.compile.UpsertCompiler$UpsertValuesMutationPlan.execute(UpsertCompiler.java:1202)^
^at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)^
^at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)^
^at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)^
^at 
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)^
^at 
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)^
^at 
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:173)^
^at 
org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:183)^
^at 
org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:103)^
^... 9 more^

I can query this table and have access to it,It works well:

^select * from DMP.DMP_INDEX_TEST2;^
^select * from DMP.TMP_INDEX_DMP_TEST2;^
^drop table DMP.DMP_INDEX_TEST2;^

But why did my MR task make this mistake? Any Suggestions from anyone?

  was:
First I create the table and insert the data:

 

 create table DMP.DMP_INDEX_TEST2 (id varchar not null primary key,name 
varchar,age varchar);
 upsert into DMP.DMP_INDEX_TEST2 values('id01','name01','age01');

 

The asynchronous index is then created:

 

create local index if not exists TMP_INDEX_DMP_TEST2 on DMP.DMP_INDEX_TEST2 
(name) ASYNC;

 

Because kerberos is enabled,So I need kinit HBase principal first,Then execute 
the following command:

 

HADOOP_CLASSPATH="/etc/hbase/conf" hadoop jar 
/usr/hdp/3.0.0.0-1634/phoenix/phoenix-client.jar 
org.apache.phoenix.mapreduce.index.IndexTool --schema DMP --data-table 
DMP_INDEX_TEST2 --index-table TMP_INDEX_DMP_TEST2 --output-path /hbase-backup2

 

But I got the following error:

 

Error: java.lang.RuntimeException: 
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table 
undefined. tableName=DMP.DMP_INDEX_TEST2
 at 
org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:124)
 at 
org.apache.phoenix.mapreduce.index.PhoenixIndexImportMapper.map(PhoenixIndexImportMapper.java:50)
 at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146)
 at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:799)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347)
 at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174)
 at java.security.AccessController.doPrivileged(Native Method)
 at javax.security.auth.Subject.doAs(Subject.java:422)
 at 

[jira] [Updated] (PHOENIX-5166) DELETE didn't work on phoenix

2019-02-25 Thread Yuan Yifan (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yuan Yifan updated PHOENIX-5166:

Attachment: image-2019-02-26-14-34-50-580.png

> DELETE didn't work on phoenix
> -
>
> Key: PHOENIX-5166
> URL: https://issues.apache.org/jira/browse/PHOENIX-5166
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.14.1
> Environment: Apache HBase 1.4
> Phoenix 4.14.1
>Reporter: Yuan Yifan
>Priority: Major
> Fix For: 4.15.0
>
> Attachments: image-2019-02-26-13-56-44-201.png, 
> image-2019-02-26-14-34-50-580.png
>
>
> I executed an SQL that delete some data in table T_LOCATION, the data 
> decreased.
> But there're still 256 rows of data which I can't delete them however I run 
> DELETE repeatedly.
> !image-2019-02-26-13-56-44-201.png!
>  
> I'm preparing to fix it but I don't know where the code should I debug, is 
> there any document of the structure/design of Phoenix?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5166) DELETE didn't work on phoenix

2019-02-25 Thread Yuan Yifan (JIRA)
Yuan Yifan created PHOENIX-5166:
---

 Summary: DELETE didn't work on phoenix
 Key: PHOENIX-5166
 URL: https://issues.apache.org/jira/browse/PHOENIX-5166
 Project: Phoenix
  Issue Type: Bug
Affects Versions: 4.14.1
 Environment: Apache HBase 1.4

Phoenix 4.14.1
Reporter: Yuan Yifan
 Fix For: 4.15.0
 Attachments: image-2019-02-26-13-56-44-201.png

I executed an SQL that delete some data in table T_LOCATION, the data decreased.

But there're still 256 rows of data which I can't delete them however I run 
DELETE repeatedly.

!image-2019-02-26-13-56-44-201.png!

 

I'm preparing to fix it but I don't know where the code should I debug, is 
there any document of the structure/design of Phoenix?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Assigned] (PHOENIX-4918) Apache Phoenix website Grammar page is running on an old version

2019-02-25 Thread Xinyi Yan (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xinyi Yan reassigned PHOENIX-4918:
--

  Assignee: Xinyi Yan
Attachment: PHOENIX-4918.patch

> Apache Phoenix website Grammar page is running on an old version
> 
>
> Key: PHOENIX-4918
> URL: https://issues.apache.org/jira/browse/PHOENIX-4918
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Xu Cang
>Assignee: Xinyi Yan
>Priority: Trivial
> Attachments: PHOENIX-4918.patch
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> For example this query example is incorrect: CREATE TABLE my_schema.my_table 
> ( id BIGINT not null primary key, date)
>  
> [https://phoenix.apache.org/language/index.html]
> I checked the master branch and 4.x branch, the code is correct though. 
> Meaning the website is using a very old version of phoenix.csv.
> Any plan to update it? thanks.
>  FYI [~karanmehta93]  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5164) MutableIndexIT is failing in CDH6 brach

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5164:
-
Comment: was deleted

(was: After PHOENIX-4956 this test started failing)

> MutableIndexIT is failing in CDH6 brach
> ---
>
> Key: PHOENIX-5164
> URL: https://issues.apache.org/jira/browse/PHOENIX-5164
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> Tests are failing under MutableIndexIT_localIndex= * 
> ,transactionProvider=null,columnEncoded= *



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5164) MutableIndexIT is failing in CDH6 brach

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5164:
-
Description: 
testUpdateNonIndexedColumn usecase is failing under MutableIndexIT_localIndex= 
* ,transactionProvider=null,columnEncoded= *

{code:java}
java.lang.AssertionError: Expected equality for V2, but 'v2_2'!=null
(...)
at 
org.apache.phoenix.util.IndexScrutiny.scrutinizeIndex(IndexScrutiny.java:156)
at 
org.apache.phoenix.end2end.index.MutableIndexIT.testUpdateNonIndexedColumn(MutableIndexIT.java:895)
{code}


  was:
Tests are failing under MutableIndexIT_localIndex= * 
,transactionProvider=null,columnEncoded= *




> MutableIndexIT is failing in CDH6 brach
> ---
>
> Key: PHOENIX-5164
> URL: https://issues.apache.org/jira/browse/PHOENIX-5164
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> testUpdateNonIndexedColumn usecase is failing under 
> MutableIndexIT_localIndex= * ,transactionProvider=null,columnEncoded= *
> {code:java}
> java.lang.AssertionError: Expected equality for V2, but 'v2_2'!=null
> (...)
>   at 
> org.apache.phoenix.util.IndexScrutiny.scrutinizeIndex(IndexScrutiny.java:156)
>   at 
> org.apache.phoenix.end2end.index.MutableIndexIT.testUpdateNonIndexedColumn(MutableIndexIT.java:895)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5164) MutableIndexIT is failing in CDH6 brach

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5164:
-
Description: 
{{testUpdateNonIndexedColumn}} usecase is failing under 
{{MutableIndexIT_localIndex= * ,transactionProvider=null,columnEncoded= *}}

{code:java}
java.lang.AssertionError: Expected equality for V2, but 'v2_2'!=null
(...)
at 
org.apache.phoenix.util.IndexScrutiny.scrutinizeIndex(IndexScrutiny.java:156)
at 
org.apache.phoenix.end2end.index.MutableIndexIT.testUpdateNonIndexedColumn(MutableIndexIT.java:895)
{code}


  was:
testUpdateNonIndexedColumn usecase is failing under MutableIndexIT_localIndex= 
* ,transactionProvider=null,columnEncoded= *

{code:java}
java.lang.AssertionError: Expected equality for V2, but 'v2_2'!=null
(...)
at 
org.apache.phoenix.util.IndexScrutiny.scrutinizeIndex(IndexScrutiny.java:156)
at 
org.apache.phoenix.end2end.index.MutableIndexIT.testUpdateNonIndexedColumn(MutableIndexIT.java:895)
{code}



> MutableIndexIT is failing in CDH6 brach
> ---
>
> Key: PHOENIX-5164
> URL: https://issues.apache.org/jira/browse/PHOENIX-5164
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> {{testUpdateNonIndexedColumn}} usecase is failing under 
> {{MutableIndexIT_localIndex= * ,transactionProvider=null,columnEncoded= *}}
> {code:java}
> java.lang.AssertionError: Expected equality for V2, but 'v2_2'!=null
> (...)
>   at 
> org.apache.phoenix.util.IndexScrutiny.scrutinizeIndex(IndexScrutiny.java:156)
>   at 
> org.apache.phoenix.end2end.index.MutableIndexIT.testUpdateNonIndexedColumn(MutableIndexIT.java:895)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5165) DerivedTableIT is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5165:


 Summary: DerivedTableIT is failing in CDH6 branch
 Key: PHOENIX-5165
 URL: https://issues.apache.org/jira/browse/PHOENIX-5165
 Project: Phoenix
  Issue Type: Task
Reporter: Pedro Boado
 Fix For: 5.1.0-cdh


DerivedTableIT is failing when setting up the minicluster for the test



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5163) MutableIndexSplitForwardScanIT and MutableIndexSplitBackwardScanIT are failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5163:
-
Description: 
Both tests are failing in [localIndex=true, multiTenant=*] test runs


{code:java}
org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108 
(XCL08): Cache of region boundaries are out of date.

at 
org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:380)
at 
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
at 
org.apache.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:183)
at 
org.apache.phoenix.util.ServerUtil.parseServerExceptionOrNull(ServerUtil.java:167)
at 
org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:134)
at 
org.apache.phoenix.iterate.RoundRobinResultIterator.fetchNextBatch(RoundRobinResultIterator.java:255)
at 
org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:174)
at 
org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
at 
org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:841)
at 
org.apache.phoenix.end2end.index.MutableIndexSplitIT.splitDuringScan(MutableIndexSplitIT.java:153)
at 
org.apache.phoenix.end2end.index.MutableIndexSplitIT.testSplitDuringIndexScan(MutableIndexSplitIT.java:88)
at 
org.apache.phoenix.end2end.index.MutableIndexSplitForwardScanIT.testSplitDuringIndexScan(MutableIndexSplitForwardScanIT.java:30)
{code}


  was:Both tests are failing in [localIndex=true, multiTenant=*] test runs


> MutableIndexSplitForwardScanIT and MutableIndexSplitBackwardScanIT are 
> failing in CDH6 branch
> -
>
> Key: PHOENIX-5163
> URL: https://issues.apache.org/jira/browse/PHOENIX-5163
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> Both tests are failing in [localIndex=true, multiTenant=*] test runs
> {code:java}
> org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108 
> (XCL08): Cache of region boundaries are out of date.
>   at 
> org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:380)
>   at 
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
>   at 
> org.apache.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:183)
>   at 
> org.apache.phoenix.util.ServerUtil.parseServerExceptionOrNull(ServerUtil.java:167)
>   at 
> org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:134)
>   at 
> org.apache.phoenix.iterate.RoundRobinResultIterator.fetchNextBatch(RoundRobinResultIterator.java:255)
>   at 
> org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:174)
>   at 
> org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
>   at 
> org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:841)
>   at 
> org.apache.phoenix.end2end.index.MutableIndexSplitIT.splitDuringScan(MutableIndexSplitIT.java:153)
>   at 
> org.apache.phoenix.end2end.index.MutableIndexSplitIT.testSplitDuringIndexScan(MutableIndexSplitIT.java:88)
>   at 
> org.apache.phoenix.end2end.index.MutableIndexSplitForwardScanIT.testSplitDuringIndexScan(MutableIndexSplitForwardScanIT.java:30)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5164) MutableIndexIT is failing in CDH6 brach

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5164:
-
Description: 
Tests are failing under MutableIndexIT_localIndex= * 
,transactionProvider=null,columnEncoded= *



  was:
Tests are failing under 
MutableIndexIT_localIndex=*,transactionProvider=null,columnEncoded=*




> MutableIndexIT is failing in CDH6 brach
> ---
>
> Key: PHOENIX-5164
> URL: https://issues.apache.org/jira/browse/PHOENIX-5164
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> Tests are failing under MutableIndexIT_localIndex= * 
> ,transactionProvider=null,columnEncoded= *



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5164) MutableIndexIT is failing in CDH6 brach

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5164:


 Summary: MutableIndexIT is failing in CDH6 brach
 Key: PHOENIX-5164
 URL: https://issues.apache.org/jira/browse/PHOENIX-5164
 Project: Phoenix
  Issue Type: Task
Reporter: Pedro Boado
 Fix For: 5.1.0-cdh


Tests are failing under 
MutableIndexIT_localIndex=*,transactionProvider=null,columnEncoded=*





--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5163) MutableIndexSplitForwardScanIT and MutableIndexSplitBackwardScanIT are failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5163:


 Summary: MutableIndexSplitForwardScanIT and 
MutableIndexSplitBackwardScanIT are failing in CDH6 branch
 Key: PHOENIX-5163
 URL: https://issues.apache.org/jira/browse/PHOENIX-5163
 Project: Phoenix
  Issue Type: Task
Reporter: Pedro Boado
 Fix For: 5.1.0-cdh


Both tests are failing in [localIndex=true, multiTenant=*] test runs



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5161) ChangePermissionsIT is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5161:
-
Description: 
{{ChangePermissionsIT.testReadPermsOnTableIndexAndView}} is failing in cdh6 
branch - it keeps looping trying to shutdown minicluster 


  was:
{{ChangePermissionsIT.* [isNamespaceMapped=true]}} is failing in cdh6 branch
{code:java}

{code}



> ChangePermissionsIT is failing in CDH6 branch
> -
>
> Key: PHOENIX-5161
> URL: https://issues.apache.org/jira/browse/PHOENIX-5161
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> {{ChangePermissionsIT.testReadPermsOnTableIndexAndView}} is failing in cdh6 
> branch - it keeps looping trying to shutdown minicluster 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5158) TestCoveredColumnIndexCodec is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5158:
-
Affects Version/s: (was: 5.1.0-cdh)
Fix Version/s: 5.1.0-cdh

> TestCoveredColumnIndexCodec is failing in CDH6 branch
> -
>
> Key: PHOENIX-5158
> URL: https://issues.apache.org/jira/browse/PHOENIX-5158
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> {{TestCoveredColumnIndexCodec.testGeneratedIndexUpdates}} is failing in cdh6 
> branch
> {code:java}
> java.lang.AssertionError: Had some index updates, though it should have been 
> covered by the delete
> (...)
> org.apache.phoenix.hbase.index.covered.TestCoveredColumnIndexCodec.ensureNoUpdatesWhenCoveredByDelete(TestCoveredColumnIndexCodec.java:243)
>   at 
> org.apache.phoenix.hbase.index.covered.TestCoveredColumnIndexCodec.testGeneratedIndexUpdates(TestCoveredColumnIndexCodec.java:221)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5160) ConcurrentMutationsIT is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5160:


 Summary: ConcurrentMutationsIT is failing in CDH6 branch
 Key: PHOENIX-5160
 URL: https://issues.apache.org/jira/browse/PHOENIX-5160
 Project: Phoenix
  Issue Type: Task
Reporter: Pedro Boado
 Fix For: 5.1.0-cdh


{{ConcurrentMutationsIT.testDeleteRowAndUpsertValueAtSameTS1}} is failing in 
cdh6 branch
{code:java}
java.lang.AssertionError: Expected to find PK in data table: ('aa','aa')
(...)
at 
org.apache.phoenix.util.IndexScrutiny.scrutinizeIndex(IndexScrutiny.java:150)
at 
org.apache.phoenix.end2end.ConcurrentMutationsIT.testDeleteRowAndUpsertValueAtSameTS1(ConcurrentMutationsIT.java:650)
{code}




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5162) HashJoinMoreIT is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5162:


 Summary: HashJoinMoreIT is failing in CDH6 branch
 Key: PHOENIX-5162
 URL: https://issues.apache.org/jira/browse/PHOENIX-5162
 Project: Phoenix
  Issue Type: Task
Reporter: Pedro Boado
 Fix For: 5.1.0-cdh


{{HashJoinMoreIT.testBug2961}} is failing in cdh6 branch



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5161) ChangePermissionsIT is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5161:


 Summary: ChangePermissionsIT is failing in CDH6 branch
 Key: PHOENIX-5161
 URL: https://issues.apache.org/jira/browse/PHOENIX-5161
 Project: Phoenix
  Issue Type: Task
Reporter: Pedro Boado
 Fix For: 5.1.0-cdh


{{ChangePermissionsIT.* [isNamespaceMapped=true]}} is failing in cdh6 branch
{code:java}

{code}




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5159) TableDDLPermissionsIT is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5159:
-
Affects Version/s: (was: 5.1.0-cdh)
Fix Version/s: 5.1.0-cdh

> TableDDLPermissionsIT is failing in CDH6 branch
> ---
>
> Key: PHOENIX-5159
> URL: https://issues.apache.org/jira/browse/PHOENIX-5159
> Project: Phoenix
>  Issue Type: Task
>Reporter: Pedro Boado
>Priority: Major
> Fix For: 5.1.0-cdh
>
>
> {{TableDDLPermissionsIT.testAutomaticGrantWithIndexAndView[isNamespaceMapped=true]}}
>  is failing in cdh6 branch - keeps looping 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5159) TableDDLPermissionsIT is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5159:


 Summary: TableDDLPermissionsIT is failing in CDH6 branch
 Key: PHOENIX-5159
 URL: https://issues.apache.org/jira/browse/PHOENIX-5159
 Project: Phoenix
  Issue Type: Task
Affects Versions: 5.1.0-cdh
Reporter: Pedro Boado


{{TableDDLPermissionsIT.testAutomaticGrantWithIndexAndView[isNamespaceMapped=true]}}
 is failing in cdh6 branch - keeps looping 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Created] (PHOENIX-5158) TestCoveredColumnIndexCodec is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)
Pedro Boado created PHOENIX-5158:


 Summary: TestCoveredColumnIndexCodec is failing in CDH6 branch
 Key: PHOENIX-5158
 URL: https://issues.apache.org/jira/browse/PHOENIX-5158
 Project: Phoenix
  Issue Type: Task
Affects Versions: 5.1.0
Reporter: Pedro Boado


{{TestCoveredColumnIndexCodec.testGeneratedIndexUpdates}} is failing in cdh6 
branch
{code:java}
java.lang.AssertionError: Had some index updates, though it should have been 
covered by the delete
(...)
org.apache.phoenix.hbase.index.covered.TestCoveredColumnIndexCodec.ensureNoUpdatesWhenCoveredByDelete(TestCoveredColumnIndexCodec.java:243)
at 
org.apache.phoenix.hbase.index.covered.TestCoveredColumnIndexCodec.testGeneratedIndexUpdates(TestCoveredColumnIndexCodec.java:221)
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-5158) TestCoveredColumnIndexCodec is failing in CDH6 branch

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-5158:
-
Affects Version/s: (was: 5.1.0)
   5.1.0-cdh

> TestCoveredColumnIndexCodec is failing in CDH6 branch
> -
>
> Key: PHOENIX-5158
> URL: https://issues.apache.org/jira/browse/PHOENIX-5158
> Project: Phoenix
>  Issue Type: Task
>Affects Versions: 5.1.0-cdh
>Reporter: Pedro Boado
>Priority: Major
>
> {{TestCoveredColumnIndexCodec.testGeneratedIndexUpdates}} is failing in cdh6 
> branch
> {code:java}
> java.lang.AssertionError: Had some index updates, though it should have been 
> covered by the delete
> (...)
> org.apache.phoenix.hbase.index.covered.TestCoveredColumnIndexCodec.ensureNoUpdatesWhenCoveredByDelete(TestCoveredColumnIndexCodec.java:243)
>   at 
> org.apache.phoenix.hbase.index.covered.TestCoveredColumnIndexCodec.testGeneratedIndexUpdates(TestCoveredColumnIndexCodec.java:221)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


Re: CDH 6.X road map

2019-02-25 Thread Pedro Boado
Hi William, Mahdi.

I've put together a new patch for PHOENIX-4956 and finally opened a branch
for cdh6 support (5.x-cdh6 ). It's currently building and passing IT ( but
a few IT need to be investigated ) . Build scripts are creating parcels
that seem to run correctly in cloudera's quickstart vm cdh6 / hbase 2.

We'll try to release support for CDH 6.1 with Phoenix 5.1  - we are pretty
close right now - .

Thanks for offering your help. Work is currently needed in debugging and
finding out why a few ITs are failing. Please let's continue the
conversation in PHOENIX-4956.

Thanks!
Pedro.


On Fri, 22 Feb 2019 at 02:09, William Shen 
wrote:

> Thank you Pedro for supporting the CDH branches... Looking forward to your
> patch.
>
> On Thu, Feb 21, 2019 at 5:50 PM Pedro Boado  wrote:
>
> > Sorry for not being on top of this for a long time. I have ongoing work
> in
> > my laptop for this task. Give me a couple of days so I can review non
> > working bits and push it.
> >
> > On Fri, 22 Feb 2019, 00:45 William Shen, 
> > wrote:
> >
> > > Mahdi,
> > > I did a little bit of mailinglist/JIRA-diving, and found the following
> > > thread, which may be helpful to get you started in addition to the two
> > JIRA
> > > tickets/patches for previous work (
> > > https://issues.apache.org/jira/browse/PHOENIX-4372 and
> > > https://issues.apache.org/jira/browse/PHOENIX-4956):
> > >
> > > -- Forwarded message -
> > > From: Pedro Boado 
> > > Date: Thu, Sep 13, 2018 at 11:17 PM
> > > Subject: Re: Phoenix 5.0 + Cloudera CDH 6.0 Integration
> > > To: 
> > >
> > >
> > > Hi Curtis,
> > >
> > > As far as I am aware nobody is working on it.
> > >
> > > The approach I followed is, starting from master:
> > > - Change parent pom to use cloudera dependencies instead of Apache's
> for
> > > compilation
> > > - Make it compile (relatively easy for 4.x)
> > > - Make it pass tests (not that easy)
> > > - Once it passed, wrote the parcel module.
> > >
> > > There aren't a lot of code differences between cdh and base branches so
> > I'd
> > > try to follow the same approach - basing it on changes in the current
> > > differences-.
> > >
> > > I really think this effort is needed to try to bring both branches
> again
> > as
> > > close to each other as possible. Maybe some code differences are no
> > longer
> > > needed because CDH is already closer to the Apache version of Hadoop
> 3.0
> > > and Hbase 2.0 than it was when I did the migration.
> > >
> > > Hope it helps,
> > > Pedro.
> > >
> > > On 14 Sep 2018 04:57, "Curtis Howard" 
> > > wrote:
> > >
> > > Hi all,
> > >
> > > Is there anyone working towards Phoenix 5.0 / Cloudera (CDH) 6.0
> > > integration at this point?  I could not find any related JIRA for this
> > > after a quick search, and wanted to check here first before adding one.
> > >
> > > If I were to attempt this myself, is there a suggested approach?  I can
> > see
> > > from previous 4.x-cdh5.* branches supporting these releases that the
> > > changes for PHOENIX-4372 (
> > > https://issues.apache.org/jira/browse/PHOENIX-4372
> > > )
> > > move the builds to CDH dependencies - for example:
> > >
> > >
> >
> https://github.com/apache/phoenix/commit/024f0f22a5929da6f095dc0025b8e899e2f0c47b
> > >
> > > Would following the pattern of that commit (or attempting a
> cherry-pick)
> > > onto the the v5.0.0-HBase-2.0 tagged release (
> > > https://github.com/apache/phoenix/tree/v5.0.0-HBase-2.0) be a
> reasonable
> > > starting point?
> > >
> > > Thanks in advance
> > >
> > > Curtis
> > >
> > > On Wed, Feb 20, 2019 at 1:28 PM William Shen <
> wills...@marinsoftware.com
> > >
> > > wrote:
> > >
> > > > Same here. Would love to help with adding more CDH versions, if
> someone
> > > > can help guide us on how to best go about it based on the current cdh
> > > > branches.
> > > >
> > > > On Tue, Feb 12, 2019 at 5:10 PM Mahdi Salarkia
> >  > > >
> > > > wrote:
> > > >
> > > >> Hi
> > > >> Is there a plan to release a Hbase-2.0-CDH (Cloudera 6.X) compatible
> > > >> version of Phoenix anytime soon?
> > > >> I can see Phoenix currently supports older versions of CDH (5.11,
> ...)
> > > but
> > > >> doesn't seem to be much work being done for the version 6.
> > > >> P.S : I'll be happy to help given instructions to help build the CDH
> > 6.X
> > > >> version
> > > >>
> > > >> Thanks
> > > >> Mehdi
> > > >>
> > > >
> > >
> >
>


[jira] [Updated] (PHOENIX-4956) Distribution of Apache Phoenix 5.1 for CDH 6.1

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-4956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-4956:
-
Attachment: PHOENIX-4956-FINAL.patch

> Distribution of Apache Phoenix 5.1 for CDH 6.1
> --
>
> Key: PHOENIX-4956
> URL: https://issues.apache.org/jira/browse/PHOENIX-4956
> Project: Phoenix
>  Issue Type: Task
>Reporter: Curtis Howard
>Assignee: Pedro Boado
>Priority: Minor
> Attachments: PHOENIX-4956-FINAL.patch, PHOENIX-4956.patch
>
>
> Integration of Phoenix 5.x using CDH 6 dependencies



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-4956) Distribution of Apache Phoenix 5.1 for CDH 6.1

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-4956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-4956:
-
Attachment: (was: PHOENIX-4956-v2.patch)

> Distribution of Apache Phoenix 5.1 for CDH 6.1
> --
>
> Key: PHOENIX-4956
> URL: https://issues.apache.org/jira/browse/PHOENIX-4956
> Project: Phoenix
>  Issue Type: Task
>Reporter: Curtis Howard
>Assignee: Pedro Boado
>Priority: Minor
> Attachments: PHOENIX-4956.patch
>
>
> Integration of Phoenix 5.x using CDH 6 dependencies



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-4956) Distribution of Apache Phoenix 5.1 for CDH 6.1

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-4956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-4956:
-
Summary: Distribution of Apache Phoenix 5.1 for CDH 6.1  (was: Distribution 
of Apache Phoenix 5.0 for CDH 6.0)

> Distribution of Apache Phoenix 5.1 for CDH 6.1
> --
>
> Key: PHOENIX-4956
> URL: https://issues.apache.org/jira/browse/PHOENIX-4956
> Project: Phoenix
>  Issue Type: Task
>Reporter: Curtis Howard
>Assignee: Pedro Boado
>Priority: Minor
> Attachments: PHOENIX-4956-v2.patch, PHOENIX-4956.patch
>
>
> Integration of Phoenix 5.x using CDH 6 dependencies



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (PHOENIX-4956) Distribution of Apache Phoenix 5.0 for CDH 6.0

2019-02-25 Thread Pedro Boado (JIRA)


 [ 
https://issues.apache.org/jira/browse/PHOENIX-4956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pedro Boado updated PHOENIX-4956:
-
Attachment: PHOENIX-4956-v2.patch

> Distribution of Apache Phoenix 5.0 for CDH 6.0
> --
>
> Key: PHOENIX-4956
> URL: https://issues.apache.org/jira/browse/PHOENIX-4956
> Project: Phoenix
>  Issue Type: Task
>Reporter: Curtis Howard
>Assignee: Pedro Boado
>Priority: Minor
> Attachments: PHOENIX-4956-v2.patch, PHOENIX-4956.patch
>
>
> Integration of Phoenix 5.x using CDH 6 dependencies



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)