[jira] [Commented] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-09-26 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15524231#comment-15524231
 ] 

prakul agarwal commented on PHOENIX-3181:
-

Oh wow! seems we got some consistency. Its so weird it worked on HBASE 1.2. 
I had been travelling so was unable to take a look. I'll apply the patches and 
see what the present status is.
thanks

> Run test methods in parallel to reduce test suite run time
> --
>
> Key: PHOENIX-3181
> URL: https://issues.apache.org/jira/browse/PHOENIX-3181
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: James Taylor
> Attachments: PHOENIX-3181_4.x-HBase-1.1_WIP.patch, 
> PHOENIX-3181_v1.patch, PHOENIX-3181_v2.patch, PHOENIX-3181_v3.patch, 
> PHOENIX-3181_v4.patch, PHOENIX-3181_v5.patch, PHOENIX-3181_v6.patch, 
> PHOENIX-3181_v7.patch, PHOENIX-3181_v8.patch, 
> parallelize_4.x-Hbase1.1_wip.patch, serverLogForParallelTests.txt
>
>
> With PHOENIX-3036, the tests within a test class can be executed in parallel 
> since the table names won't conflict. This should greatly reduce the time 
> taken to run all of our tests.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-09-09 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3181:

Attachment: PHOENIX-3181_4.x-HBase-1.1_WIP.patch

> Run test methods in parallel to reduce test suite run time
> --
>
> Key: PHOENIX-3181
> URL: https://issues.apache.org/jira/browse/PHOENIX-3181
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
> Attachments: PHOENIX-3181_4.x-HBase-1.1_WIP.patch, 
> parallelize_4.x-Hbase1.1_wip.patch
>
>
> With PHOENIX-3036, the tests within a test class can be executed in parallel 
> since the table names won't conflict. This should greatly reduce the time 
> taken to run all of our tests.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-09-09 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15477870#comment-15477870
 ] 

prakul agarwal commented on PHOENIX-3181:
-

I'm using FailSafe parallel = method and threadCount ={5,10,50,100} to execute 
a bunch of test classes with forkCount = {2,3,4,5}. The integration-test phase 
is completing sometimes and getting stuck for long the other times. When it is 
getting stuck it is taking > 20 min than normal execution to complete.

In case when tests are getting stuck I notice that the log files 
(failsafe-reports folder) of individual test classes are generated each time 
consistently but the summary file generation does't happens for long. Also one 
surefire-booter jvm lingers on while others are killed.

When I execute in with forkCount = 1 the test execution probably doesnt start 
at all (Failsafe-reports folder is not generated, surefire tmp files are ). If 
I reduce the number of test classes to be executed (with forkCount = 1) then 
the execution is completing normally. 

I'm using reuseForks = true and have tried execution after removing all fork 
related settings.

Configuration:
Using Maven 3.3.9, maven-eclipse-plugin 2.9, failsafe 2.19.1, surefire 2.19.1.
OS name: "mac os x", version: "10.11.6", Intel 2.8 GHz i7, 16GB DDR3 RAM.
JDK 1.7.0_8

> Run test methods in parallel to reduce test suite run time
> --
>
> Key: PHOENIX-3181
> URL: https://issues.apache.org/jira/browse/PHOENIX-3181
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
> Attachments: parallelize_4.x-Hbase1.1_wip.patch
>
>
> With PHOENIX-3036, the tests within a test class can be executed in parallel 
> since the table names won't conflict. This should greatly reduce the time 
> taken to run all of our tests.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Comment Edited] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-09-07 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15471864#comment-15471864
 ] 

prakul agarwal edited comment on PHOENIX-3210 at 9/7/16 9:29 PM:
-

[~samarthjain] I have moved some tests from DateTimeIT to DateTime2IT. 
 DateTime2IT has tests which are creating there own  tables for testing 
purpose, whereas DateTimeIT relies on @Before to create the tables. So we are 
creating unnecessary tables presently. 
I thought we can bifurcate them.What do you think ?


was (Author: prakul):
[~samarthjain] I have moved some tests from DateTimeIT to DateTime2IT. 
 DateTime2IT has tests which are creating there own  tables for testing 
purpose, whereas DateTimeIT relies on @Before to create the tables. So we are 
creating unnecessary tables presently.

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
> Attachments: PHOENIX-3210.patch, PHOENIX-3210_v2.patch
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-09-07 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15471864#comment-15471864
 ] 

prakul agarwal commented on PHOENIX-3210:
-

[~samarthjain] I have moved some tests from DateTimeIT to DateTime2IT. 
 DateTime2IT has tests which are creating there own  tables for testing 
purpose, whereas DateTimeIT relies on @Before to create the tables. So we are 
creating unnecessary tables presently.

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
> Attachments: PHOENIX-3210.patch, PHOENIX-3210_v2.patch
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-3253) Make changes in these classes for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)
prakul agarwal created PHOENIX-3253:
---

 Summary: Make changes in these classes for method level 
parallelization in BaseHBaseManagedTimeTableReuseIT
 Key: PHOENIX-3253
 URL: https://issues.apache.org/jira/browse/PHOENIX-3253
 Project: Phoenix
  Issue Type: Task
Reporter: prakul agarwal


error log
{code}  
GroupByCaseIT.testScanUri:172 expected: but was:
   StoreNullsIT.testQueryingHistory:116
  PhoenixTraceReaderIT.testMultipleSpans:122->validateTraces:132 Got an 
unexpected traceid expected:<12345> but was:<987654>
  TransactionIT.testTxnClosedCorrecty:152 There should be no invalid 
transactions
  DynamicUpsertIT.testFullUpsert:152 expected:<[a]Value> but was:<[DynCol]Value>
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-3253) Make changes in these classes for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-3253:
---

Assignee: prakul agarwal

> Make changes in these classes for method level parallelization in 
> BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3253
> URL: https://issues.apache.org/jira/browse/PHOENIX-3253
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>
> error log
> {code}  
> GroupByCaseIT.testScanUri:172 expected: but was:
>StoreNullsIT.testQueryingHistory:116
>   PhoenixTraceReaderIT.testMultipleSpans:122->validateTraces:132 Got an 
> unexpected traceid expected:<12345> but was:<987654>
>   TransactionIT.testTxnClosedCorrecty:152 There should be no invalid 
> transactions
>   DynamicUpsertIT.testFullUpsert:152 expected:<[a]Value> but 
> was:<[DynCol]Value>
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-3252) Make changes in PhoenixRuntimeIT for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)
prakul agarwal created PHOENIX-3252:
---

 Summary: Make changes in  PhoenixRuntimeIT for method level 
parallelization in BaseHBaseManagedTimeTableReuseIT
 Key: PHOENIX-3252
 URL: https://issues.apache.org/jira/browse/PHOENIX-3252
 Project: Phoenix
  Issue Type: Task
Reporter: prakul agarwal


{code}
  
PhoenixRuntimeIT.testGetTenantIdExpressionForSaltedTable:81->testGetTenantIdExpression:117->assertTenantIds:76
 expected:<[, t1]> but was:<[, , t1, t1]>
  
PhoenixRuntimeIT.testGetTenantIdExpressionForUnsaltedTable:86->testGetTenantIdExpression:117->assertTenantIds:76
 expected:<[, t1]> but was:<[, , t1, t1]>
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-3251) Make changes in HashJoinMoreIT for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-3251:
---

Assignee: prakul agarwal

> Make changes in   HashJoinMoreIT for method level parallelization in 
> BaseHBaseManagedTimeTableReuseIT
> -
>
> Key: PHOENIX-3251
> URL: https://issues.apache.org/jira/browse/PHOENIX-3251
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>
> {code}
>   HashJoinMoreIT.assertNoUnfreedMemory:112 expected:<0> but was:<908>
>   HashJoinMoreIT.assertNoUnfreedMemory:112 expected:<0> but was:<2811>
>   HashJoinMoreIT.testBug2894:843 » PhoenixIO 
> org.apache.phoenix.exception.Phoeni...
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-3250) Make changes in test classes with member variable for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-3250:
---

Assignee: prakul agarwal

> Make changes in test classes with member variable for method level 
> parallelization in BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3250
> URL: https://issues.apache.org/jira/browse/PHOENIX-3250
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>
> {code}
>   ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsert1:268
>   ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsert4:337
>   ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsert2:281 » 
> TableAlreadyExists
>   ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsertSelect1:354 » 
> TableAlreadyExists
>   ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsertSelect3:450 » 
> PhoenixIO
>   PrimitiveTypeIT.testBooleanAsObject:219 » PhoenixIO
>   PrimitiveTypeIT.testCompareLongGTDecimal:60 » PhoenixIO
>   PrimitiveTypeIT.testCompareLongGTEDecimal:81 » PhoenixIO
>   PrimitiveTypeIT.testCompareLongGTEDecimal2:158 » PhoenixIO
>   PrimitiveTypeIT.testCompareLongLTDecimal2:177 » PhoenixIO
>   PrimitiveTypeIT.testCompareLongLTEDecimal:121 » PhoenixIO
>   RegexpSplitFunctionIT.testSplit_AlternateSeparator:144 array lengths 
> differed, expected.length=3 actual.length=1
>   RegexpSplitFunctionIT.testSplit_NoSplitString:170 array lengths differed, 
> expected.length=1 actual.length=3
>   RegexpSplitFunctionIT.testSplit_NullDynamicSeparator:231 expected null, but 
> was:<['ONE', 'TWO', 'THREE']>
>   RegexpSplitFunctionIT.testSplit_NullString:207 expected null, but 
> was:<['ONE', 'TWO', 'THREE']>
>   RegexpSplitFunctionIT.testSplit_PatternBasedSplit:183 array lengths 
> differed, expected.length=4 actual.length=1
>   RegexpSplitFunctionIT.testSplit_PatternEscape:196 array lengths differed, 
> expected.length=3 actual.length=1
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
>   ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
> undef...
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-3252) Make changes in PhoenixRuntimeIT for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-3252:
---

Assignee: prakul agarwal

> Make changes in  PhoenixRuntimeIT for method level parallelization in 
> BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3252
> URL: https://issues.apache.org/jira/browse/PHOENIX-3252
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>
> {code}
>   
> PhoenixRuntimeIT.testGetTenantIdExpressionForSaltedTable:81->testGetTenantIdExpression:117->assertTenantIds:76
>  expected:<[, t1]> but was:<[, , t1, t1]>
>   
> PhoenixRuntimeIT.testGetTenantIdExpressionForUnsaltedTable:86->testGetTenantIdExpression:117->assertTenantIds:76
>  expected:<[, t1]> but was:<[, , t1, t1]>
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-3251) Make changes in HashJoinMoreIT for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)
prakul agarwal created PHOENIX-3251:
---

 Summary: Make changes in   HashJoinMoreIT for method level 
parallelization in BaseHBaseManagedTimeTableReuseIT
 Key: PHOENIX-3251
 URL: https://issues.apache.org/jira/browse/PHOENIX-3251
 Project: Phoenix
  Issue Type: Task
Reporter: prakul agarwal


{code}
  HashJoinMoreIT.assertNoUnfreedMemory:112 expected:<0> but was:<908>
  HashJoinMoreIT.assertNoUnfreedMemory:112 expected:<0> but was:<2811>
  HashJoinMoreIT.testBug2894:843 » PhoenixIO 
org.apache.phoenix.exception.Phoeni...
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-3250) Make changes in test classes with member variable for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)
prakul agarwal created PHOENIX-3250:
---

 Summary: Make changes in test classes with member variable for 
method level parallelization in BaseHBaseManagedTimeTableReuseIT
 Key: PHOENIX-3250
 URL: https://issues.apache.org/jira/browse/PHOENIX-3250
 Project: Phoenix
  Issue Type: Task
Reporter: prakul agarwal


{code}
  ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsert1:268
  ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsert4:337
  ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsert2:281 » 
TableAlreadyExists
  ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsertSelect1:354 » 
TableAlreadyExists
  ArrayToStringFunctionIT.testArrayToStringFunctionWithUpsertSelect3:450 » 
PhoenixIO

  PrimitiveTypeIT.testBooleanAsObject:219 » PhoenixIO
  PrimitiveTypeIT.testCompareLongGTDecimal:60 » PhoenixIO
  PrimitiveTypeIT.testCompareLongGTEDecimal:81 » PhoenixIO
  PrimitiveTypeIT.testCompareLongGTEDecimal2:158 » PhoenixIO
  PrimitiveTypeIT.testCompareLongLTDecimal2:177 » PhoenixIO
  PrimitiveTypeIT.testCompareLongLTEDecimal:121 » PhoenixIO

  RegexpSplitFunctionIT.testSplit_AlternateSeparator:144 array lengths 
differed, expected.length=3 actual.length=1
  RegexpSplitFunctionIT.testSplit_NoSplitString:170 array lengths differed, 
expected.length=1 actual.length=3
  RegexpSplitFunctionIT.testSplit_NullDynamicSeparator:231 expected null, but 
was:<['ONE', 'TWO', 'THREE']>
  RegexpSplitFunctionIT.testSplit_NullString:207 expected null, but 
was:<['ONE', 'TWO', 'THREE']>
  RegexpSplitFunctionIT.testSplit_PatternBasedSplit:183 array lengths differed, 
expected.length=4 actual.length=1
  RegexpSplitFunctionIT.testSplit_PatternEscape:196 array lengths differed, 
expected.length=3 actual.length=1

  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...
  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...
  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...
  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...
  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...
  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...
  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...
  ToCharFunctionIT.initTable:114 » TableNotFound ERROR 1012 (42M03): Table 
undef...

{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3249) Make changes in LocalIndexIT for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3249:

Description: 
Error Log
{code}
  
LocalIndexIT.testBuildIndexWhenUserTableAlreadyHasData:280->createBaseTable:99 
» PhoenixIO
  
LocalIndexIT.testDropLocalIndexShouldDeleteDataFromLocalIndexTable:619->createBaseTable:99
 » PhoenixIO
  LocalIndexIT.testDropLocalIndexTable:217->createBaseTable:99 » PhoenixIO 
org.a...
  
LocalIndexIT.testIndexPlanSelectionIfBothGlobalAndLocalIndexesHasSameColumnsAndOrder:596->createBaseTable:99
 » PhoenixIO
  
LocalIndexIT.testLocalIndexCreationWithSaltingShouldFail:166->createBaseTable:99
 » PhoenixIO
  
LocalIndexIT.testLocalIndexCreationWithSplitsShouldFail:147->createBaseTable:99 
» PhoenixIO
  LocalIndexIT.testLocalIndexRoundTrip:124->createBaseTable:99 » PhoenixIO 
org.a...
  
LocalIndexIT.testLocalIndexRowsShouldBeDeletedWhenUserTableRowsDeleted:665->createBaseTable:99
 » PhoenixIO
  LocalIndexIT.testLocalIndexScanWithInList:762->createBaseTable:99 » PhoenixIO 
...
  LocalIndexIT.testLocalIndexScanWithSmallChunks:909->createBaseTable:99 » 
PhoenixIO
  LocalIndexIT.testLocalIndexScan:320->createBaseTable:99 » PhoenixIO 
org.apache...
  
LocalIndexIT.testLocalIndexTableRegionSplitPolicyAndSplitKeys:187->createBaseTable:99
 » PhoenixIO
  LocalIndexIT.testLocalIndexesOnTableWithImmutableRows:715->createBaseTable:99 
» PhoenixIO
  LocalIndexIT.testPutsToLocalIndexTable:240->createBaseTable:99 » PhoenixIO 
org...
  
LocalIndexIT.testScanWhenATableHasMultipleLocalIndexes:690->createBaseTable:99 
» PhoenixIO

{code}

> Make changes in  LocalIndexIT for method level parallelization in 
> BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3249
> URL: https://issues.apache.org/jira/browse/PHOENIX-3249
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>
> Error Log
> {code}
>   
> LocalIndexIT.testBuildIndexWhenUserTableAlreadyHasData:280->createBaseTable:99
>  » PhoenixIO
>   
> LocalIndexIT.testDropLocalIndexShouldDeleteDataFromLocalIndexTable:619->createBaseTable:99
>  » PhoenixIO
>   LocalIndexIT.testDropLocalIndexTable:217->createBaseTable:99 » PhoenixIO 
> org.a...
>   
> LocalIndexIT.testIndexPlanSelectionIfBothGlobalAndLocalIndexesHasSameColumnsAndOrder:596->createBaseTable:99
>  » PhoenixIO
>   
> LocalIndexIT.testLocalIndexCreationWithSaltingShouldFail:166->createBaseTable:99
>  » PhoenixIO
>   
> LocalIndexIT.testLocalIndexCreationWithSplitsShouldFail:147->createBaseTable:99
>  » PhoenixIO
>   LocalIndexIT.testLocalIndexRoundTrip:124->createBaseTable:99 » PhoenixIO 
> org.a...
>   
> LocalIndexIT.testLocalIndexRowsShouldBeDeletedWhenUserTableRowsDeleted:665->createBaseTable:99
>  » PhoenixIO
>   LocalIndexIT.testLocalIndexScanWithInList:762->createBaseTable:99 » 
> PhoenixIO ...
>   LocalIndexIT.testLocalIndexScanWithSmallChunks:909->createBaseTable:99 » 
> PhoenixIO
>   LocalIndexIT.testLocalIndexScan:320->createBaseTable:99 » PhoenixIO 
> org.apache...
>   
> LocalIndexIT.testLocalIndexTableRegionSplitPolicyAndSplitKeys:187->createBaseTable:99
>  » PhoenixIO
>   
> LocalIndexIT.testLocalIndexesOnTableWithImmutableRows:715->createBaseTable:99 
> » PhoenixIO
>   LocalIndexIT.testPutsToLocalIndexTable:240->createBaseTable:99 » PhoenixIO 
> org...
>   
> LocalIndexIT.testScanWhenATableHasMultipleLocalIndexes:690->createBaseTable:99
>  » PhoenixIO
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-3249) Make changes in LocalIndexIT for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-3249:
---

Assignee: prakul agarwal

> Make changes in  LocalIndexIT for method level parallelization in 
> BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3249
> URL: https://issues.apache.org/jira/browse/PHOENIX-3249
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-3249) Make changes in LocalIndexIT for method level parallelization in BaseHBaseManagedTimeTableReuseIT

2016-09-06 Thread prakul agarwal (JIRA)
prakul agarwal created PHOENIX-3249:
---

 Summary: Make changes in  LocalIndexIT for method level 
parallelization in BaseHBaseManagedTimeTableReuseIT
 Key: PHOENIX-3249
 URL: https://issues.apache.org/jira/browse/PHOENIX-3249
 Project: Phoenix
  Issue Type: Task
Reporter: prakul agarwal






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3181:

Attachment: parallelize_4.x-Hbase1.1_wip.patch

> Run test methods in parallel to reduce test suite run time
> --
>
> Key: PHOENIX-3181
> URL: https://issues.apache.org/jira/browse/PHOENIX-3181
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
> Attachments: parallelize_4.x-Hbase1.1_wip.patch
>
>
> With PHOENIX-3036, the tests within a test class can be executed in parallel 
> since the table names won't conflict. This should greatly reduce the time 
> taken to run all of our tests.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3181:

Attachment: (was: parallelize.diff)

> Run test methods in parallel to reduce test suite run time
> --
>
> Key: PHOENIX-3181
> URL: https://issues.apache.org/jira/browse/PHOENIX-3181
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
> Attachments: parallelize_4.x-Hbase1.1_wip.patch
>
>
> With PHOENIX-3036, the tests within a test class can be executed in parallel 
> since the table names won't conflict. This should greatly reduce the time 
> taken to run all of our tests.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-09-06 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3181:

Attachment: parallelize.diff

> Run test methods in parallel to reduce test suite run time
> --
>
> Key: PHOENIX-3181
> URL: https://issues.apache.org/jira/browse/PHOENIX-3181
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
> Attachments: parallelize.diff
>
>
> With PHOENIX-3036, the tests within a test class can be executed in parallel 
> since the table names won't conflict. This should greatly reduce the time 
> taken to run all of our tests.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-09-06 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15468994#comment-15468994
 ] 

prakul agarwal commented on PHOENIX-3181:
-

Attaching a diff for executing test suite with method level parallelization. . 
The integration-test phase completed in ~6 min (usually it takes ~20 min ) with 
5 forks and threadCount = 5. ~20 tests are failing, whose related classes have 
been commented out in the attached diff. I have also tinkered with various 
settings in Phoenix configurations.



> Run test methods in parallel to reduce test suite run time
> --
>
> Key: PHOENIX-3181
> URL: https://issues.apache.org/jira/browse/PHOENIX-3181
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>
> With PHOENIX-3036, the tests within a test class can be executed in parallel 
> since the table names won't conflict. This should greatly reduce the time 
> taken to run all of our tests.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-09-01 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15456680#comment-15456680
 ] 

prakul agarwal commented on PHOENIX-3201:
-

[~samarthjain] Have attached the patches for the said branch.

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch, PHOENIX-3201_4.x-HBase-0.98.patch, 
> PHOENIX-3201_4.x-HBase-1.1.patch, PHOENIX-3201_master.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-09-01 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: PHOENIX-3201_4.x-HBase-0.98.patch
PHOENIX-3201_4.x-HBase-1.1.patch
PHOENIX-3201_master.patch

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch, PHOENIX-3201_4.x-HBase-0.98.patch, 
> PHOENIX-3201_4.x-HBase-1.1.patch, PHOENIX-3201_master.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-09-01 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3210:

Attachment: PHOENIX-3210_v2.patch

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
> Attachments: PHOENIX-3210.patch, PHOENIX-3210_v2.patch
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-09-01 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15456363#comment-15456363
 ] 

prakul agarwal commented on PHOENIX-3210:
-

[~jamestaylor] Thanks a lot for feedback. Added a patch with all suggested 
changes.

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
> Attachments: PHOENIX-3210.patch, PHOENIX-3210_v2.patch
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-31 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3210:

Attachment: PHOENIX-3210.patch

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
> Attachments: PHOENIX-3210.patch
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-29 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15447653#comment-15447653
 ] 

prakul agarwal commented on PHOENIX-3210:
-

[~jamestaylor] I tried both the suggestions decimal without scale and 
precision, and using constant like 123e2. Neither repros the error. I'm trying 
to trace what values are parsed as Double. Otherwise I'll be submitting a patch 
with fixes you suggested.

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-29 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15447199#comment-15447199
 ] 

prakul agarwal commented on PHOENIX-3201:
-

[~jamestaylor] Submitted a rebased patch.

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-29 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: PHOENIX-3201.patch

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-29 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: (was: PHOENIX-3201.patch)

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Comment Edited] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-29 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15447135#comment-15447135
 ] 

prakul agarwal edited comment on PHOENIX-3210 at 8/29/16 9:42 PM:
--

I tried creating tables with
{code}
CREATE TABLE T(K INTEGER PRIMARY KEY, V DECIMAL(10,2));
or CREATE TABLE T(K INTEGER PRIMARY KEY, V DOUBLE);
{code}
and upserting a bunch of possibilities like 
{code}
ps = UPSERT INTO T VALUES(1,?);
ps.setDouble(1,222.333);
or ps.setBigDecimal(1,BigDecimal.valueOf(100.333));
{code}


was (Author: prakul):
I tried creating tables with
{code}
CREATE TABLE T(K INTEGER PRIMARY KEY, V DECIMAL(10,2));
or CREATE TABLE T(K INTEGER PRIMARY KEY, V DOUBLE);
{code}
and upserting a bunch of possibilities like 
{code}
ps = UPSERT INTO T VALUES(1,?);
ps.setDouble(222.333);
or ps.setBigDecimal(1,BigDecimal.valueOf(100.333));
{code}

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-29 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15447068#comment-15447068
 ] 

prakul agarwal commented on PHOENIX-3210:
-

[~shehzaadn] I have been unable to repro the query. Can you find the table on 
which it was executed so I can know how its column have been defined ?

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-26 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3036:

Attachment: PHOENIX-3036_4.x-HBase-1.1.patch

> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>Assignee: prakul agarwal
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3036.patch, PHOENIX-3036_4.x-HBase-1.1.patch, 
> PHOENIX-3036_addendum.patch, PHOENIX-3036_v2.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-26 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3036:

Attachment: PHOENIX-3036_master.patch

> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>Assignee: prakul agarwal
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3036.patch, PHOENIX-3036_4.x-HBase-1.1.patch, 
> PHOENIX-3036_addendum.patch, PHOENIX-3036_master.patch, PHOENIX-3036_v2.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: PHOENIX-3201.patch

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: (was: PHOENIX-3201.patch)

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: (was: PHOENIX-3201.patch)

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: PHOENIX-3201.patch

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch, PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3210) Exception trying to cast Double to BigDecimal in UpsertCompiler

2016-08-25 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15437834#comment-15437834
 ] 

prakul agarwal commented on PHOENIX-3210:
-

I'm on it.

> Exception trying to cast Double to BigDecimal in UpsertCompiler
> ---
>
> Key: PHOENIX-3210
> URL: https://issues.apache.org/jira/browse/PHOENIX-3210
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.7.0
>Reporter: Shehzaad Nakhoda
>Assignee: prakul agarwal
>  Labels: SFDC
> Fix For: 4.9.0, 4.8.1
>
>
> We have an UPSERT statement that is resulting in this stack trace. 
> Unfortunately I can't get a hold of the actual Upsert statement since we 
> don't log it. 
> Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to 
> java.math.BigDecimal
>  Cause0-StackTrace: 
>   at 
> org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
>   at 
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
>   at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
>   at 
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
>   at 
> phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: PHOENIX-3201.patch

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: (was: PHOENIX-3201.patch)

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15437431#comment-15437431
 ] 

prakul agarwal commented on PHOENIX-3201:
-

Raising a pull request on github (as git format-patch... is generating a 
weirdly big patch)
https://github.com/apache/phoenix/pull/197

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

2016-08-25 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3201:

Attachment: PHOENIX-3201.patch

> Implement DAYOFWEEK and DAYOFYEAR built-in functions
> 
>
> Key: PHOENIX-3201
> URL: https://issues.apache.org/jira/browse/PHOENIX-3201
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>  Labels: newbie
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3201.patch
>
>
> DAYOFWEEK() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645
> DAYOFYEAR() as documented here: 
> https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-15 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3036:

Attachment: PHOENIX-3036.patch

> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>Assignee: prakul agarwal
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3036.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-08-15 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3036:

Attachment: (was: PHOENIX-3036.patch)

> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>Assignee: prakul agarwal
> Fix For: 4.9.0
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Resolved] (PHOENIX-3145) Deriving IndexIT from BaseHBaseManagedTimeTableReuseIT causes tests to timeout

2016-08-15 Thread prakul agarwal (JIRA)

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

prakul agarwal resolved PHOENIX-3145.
-
Resolution: Fixed

> Deriving IndexIT from BaseHBaseManagedTimeTableReuseIT causes tests to timeout
> --
>
> Key: PHOENIX-3145
> URL: https://issues.apache.org/jira/browse/PHOENIX-3145
> Project: Phoenix
>  Issue Type: Bug
>Reporter: James Taylor
>Assignee: prakul agarwal
>
> It appears that deriving IndexIT from BaseHBaseManagedTimeTableReuseIT causes 
> tests to timeout. See PHOENIX-3138 which switched it back to 
> BaseHBaseManagedTimeIT. We should figure out how to prevent this and switch 
> IndexIT back to using BaseHBaseManagedTimeTableReuseIT.
> FYI, [~samarthjain]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-3153) Remaining phoenix IT tests to be converted to BaseHBaseManagedTimeTableReuseIT

2016-08-05 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-3153:
---

Assignee: prakul agarwal

> Remaining phoenix IT tests to be converted to BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3153
> URL: https://issues.apache.org/jira/browse/PHOENIX-3153
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>Priority: Minor
>
> The following 5 test cases follow same pattern (initJoinTableValues method 
> for table generation) and are still extending BaseHBaseManagedTimeIT .
> HashJoinIt
> SortMergeJoinIT
> HashJoinLocal index
> SubqueryIT
> SubqueryUsingSortMergeJoinIT



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3153) Remaining phoenix IT tests to be converted to BaseHBaseManagedTimeTableReuseIT

2016-08-05 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3153:

Description: 
The following 5 test cases follow same pattern (initJoinTableValues method for 
table generation) and are still extending BaseHBaseManagedTimeIT .

HashJoinIt
SortMergeJoinIT
HashJoinLocal index
SubqueryIT
SubqueryUsingSortMergeJoinIT

  was:
The following test class hasnt been converted to 
BaseHBaseManagedTimeTableReuseIT because of an issue in 
testSettingBaseColumnCountForMultipleViewsOnTable() test case.


UpgradeIT


The following 5 test cases follow same pattern (initJoinTableValues method for 
table generation) and are still extending BaseHBaseManagedTimeIT .

HashJoinIt
SortMergeJoinIT
HashJoinLocal index
SubqueryIT
SubqueryUsingSortMergeJoinIT


> Remaining phoenix IT tests to be converted to BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3153
> URL: https://issues.apache.org/jira/browse/PHOENIX-3153
> Project: Phoenix
>  Issue Type: Task
>Reporter: prakul agarwal
>Priority: Minor
>
> The following 5 test cases follow same pattern (initJoinTableValues method 
> for table generation) and are still extending BaseHBaseManagedTimeIT .
> HashJoinIt
> SortMergeJoinIT
> HashJoinLocal index
> SubqueryIT
> SubqueryUsingSortMergeJoinIT



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-3140) UpgradeIT.java -> testSettingBaseColumnCountForMultipleViewsOnTable() fails randomly with randomized tenantViewName and TableReuse class

2016-08-05 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-3140:
---

Assignee: prakul agarwal

> UpgradeIT.java -> testSettingBaseColumnCountForMultipleViewsOnTable() fails 
> randomly with randomized tenantViewName and TableReuse class
> 
>
> Key: PHOENIX-3140
> URL: https://issues.apache.org/jira/browse/PHOENIX-3140
> Project: Phoenix
>  Issue Type: Bug
>Reporter: prakul agarwal
>Assignee: prakul agarwal
>Priority: Minor
> Attachments: UpgradeIT.diff
>
>
> Stacktrace:
> {code}
> java.lang.AssertionError: 
> Expected :-100
> Actual   :0
>  
>   at org.junit.Assert.fail(Assert.java:88)
>   at org.junit.Assert.failNotEquals(Assert.java:834)
>   at org.junit.Assert.assertEquals(Assert.java:645)
>   at org.junit.Assert.assertEquals(Assert.java:631)
>   at 
> org.apache.phoenix.end2end.UpgradeIT.checkBaseColumnCount(UpgradeIT.java:555)
>   at 
> org.apache.phoenix.end2end.UpgradeIT.testSettingBaseColumnCountForMultipleViewsOnTable(UpgradeIT.java:453)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3140) UpgradeIT.java -> testSettingBaseColumnCountForMultipleViewsOnTable() fails randomly with randomized tenantViewName and TableReuse class

2016-08-02 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3140:

Attachment: UpgradeIT.diff

Attached is the repro

> UpgradeIT.java -> testSettingBaseColumnCountForMultipleViewsOnTable() fails 
> randomly with randomized tenantViewName and TableReuse class
> 
>
> Key: PHOENIX-3140
> URL: https://issues.apache.org/jira/browse/PHOENIX-3140
> Project: Phoenix
>  Issue Type: Bug
>Reporter: prakul agarwal
>Priority: Minor
> Attachments: UpgradeIT.diff
>
>
> Stacktrace:
> {code}
> java.lang.AssertionError: 
> Expected :-100
> Actual   :0
>  
>   at org.junit.Assert.fail(Assert.java:88)
>   at org.junit.Assert.failNotEquals(Assert.java:834)
>   at org.junit.Assert.assertEquals(Assert.java:645)
>   at org.junit.Assert.assertEquals(Assert.java:631)
>   at 
> org.apache.phoenix.end2end.UpgradeIT.checkBaseColumnCount(UpgradeIT.java:555)
>   at 
> org.apache.phoenix.end2end.UpgradeIT.testSettingBaseColumnCountForMultipleViewsOnTable(UpgradeIT.java:453)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-3140) UpgradeIT.java -> testSettingBaseColumnCountForMultipleViewsOnTable() fails randomly with randomized tenantViewName and TableReuse class

2016-08-02 Thread prakul agarwal (JIRA)
prakul agarwal created PHOENIX-3140:
---

 Summary: UpgradeIT.java -> 
testSettingBaseColumnCountForMultipleViewsOnTable() fails randomly with 
randomized tenantViewName and TableReuse class
 Key: PHOENIX-3140
 URL: https://issues.apache.org/jira/browse/PHOENIX-3140
 Project: Phoenix
  Issue Type: Bug
Reporter: prakul agarwal
Priority: Minor



Stacktrace:
{code}
java.lang.AssertionError: 
Expected :-100
Actual   :0
 


at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:834)
at org.junit.Assert.assertEquals(Assert.java:645)
at org.junit.Assert.assertEquals(Assert.java:631)
at 
org.apache.phoenix.end2end.UpgradeIT.checkBaseColumnCount(UpgradeIT.java:555)
at 
org.apache.phoenix.end2end.UpgradeIT.testSettingBaseColumnCountForMultipleViewsOnTable(UpgradeIT.java:453)

{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Comment Edited] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-07-28 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15398676#comment-15398676
 ] 

prakul agarwal edited comment on PHOENIX-3036 at 7/29/16 4:12 AM:
--

- total number of IT classes to convert (~80)
- total number IT classes converted (~75)

TIME TAKEN
 ( AFTER REFACTORING )
BaseHBaseManagedTimeIT
Total time:  08:34 min
HBaseManagedTimeTableReuseTest
Total time: 20:44 min

 ( BEFORE REFACTORING )
BaseHBaseManagedTimeIT
Total time: 32:58 min
HBaseManagedTimeTableReuseTest
Total time: 08:12 min



was (Author: prakul):
- total number of IT classes to convert (~80)
- total number IT classes converted (75)

TIME TAKEN
 ( AFTER REFACTORING )
BaseHBaseManagedTimeIT
Total time:  08:34 min
HBaseManagedTimeTableReuseTest
Total time: 20:44 min

 ( BEFORE REFACTORING )
BaseHBaseManagedTimeIT
Total time: 32:58 min
HBaseManagedTimeTableReuseTest
Total time: 08:12 min


> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>Assignee: prakul agarwal
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3036.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-07-28 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15398679#comment-15398679
 ] 

prakul agarwal commented on PHOENIX-3036:
-

The following 5 test cases follow same pattern (initJoinTableValues method for 
table generation) and are still extending BaseHBaseManagedTimeIT .

HashJoinIt
SortMergeJoinIT
HashJoinLocal index
SubqueryIT
SubqueryUsingSortMergeJoinIT



> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>Assignee: prakul agarwal
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3036.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (PHOENIX-2916) Need a client-side level property to control write timeout

2016-07-18 Thread prakul agarwal (JIRA)

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

prakul agarwal reassigned PHOENIX-2916:
---

Assignee: prakul agarwal

> Need a client-side level property to control write timeout
> --
>
> Key: PHOENIX-2916
> URL: https://issues.apache.org/jira/browse/PHOENIX-2916
> Project: Phoenix
>  Issue Type: New Feature
>Reporter: Alex Warshavsky
>Assignee: prakul agarwal
>Priority: Minor
>
> Currently, there's a client side property phoenix.query.timeoutMs which 
> allows query to timeout after the specified time. However, there's no 
> equivalent property to allow upserts (writes) to timeout if the client 
> requires a shorted wait time than the default in Phoenix/HBase. This should 
> apply to the underlying operations related to writes - upsert, commit. Also 
> it should control timeout for writes in the HBase client, which might include 
> Zookeeper client timeout as well.
> Proposed property name: phoenix.update.timeoutMs



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (PHOENIX-3077) Add documentation for APPEND_ONLY_SCHEMA, AUTO_PARTITION_SEQ

2016-07-15 Thread prakul agarwal (JIRA)
prakul agarwal created PHOENIX-3077:
---

 Summary: Add documentation for APPEND_ONLY_SCHEMA, 
AUTO_PARTITION_SEQ
 Key: PHOENIX-3077
 URL: https://issues.apache.org/jira/browse/PHOENIX-3077
 Project: Phoenix
  Issue Type: Task
Reporter: prakul agarwal
Assignee: Thomas D'Silva
Priority: Minor






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-07-12 Thread prakul agarwal (JIRA)

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

prakul agarwal updated PHOENIX-3036:

Attachment: PHOENIX-3036.patch

> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>Assignee: prakul agarwal
> Attachments: PHOENIX-3036.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (PHOENIX-3036) Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT

2016-06-30 Thread prakul agarwal (JIRA)

[ 
https://issues.apache.org/jira/browse/PHOENIX-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15357748#comment-15357748
 ] 

prakul agarwal commented on PHOENIX-3036:
-

I will be submitting a patch soon.

> Modify phoenix IT tests to extend BaseHBaseManagedTimeTableReuseIT
> --
>
> Key: PHOENIX-3036
> URL: https://issues.apache.org/jira/browse/PHOENIX-3036
> Project: Phoenix
>  Issue Type: Improvement
>Reporter: Samarth Jain
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)