subject:"\[jira\] \[Commented\] \(HIVE\-22473\) Avoid reading table as ACID when table name is starting with \"delta\", but table is not transactional"

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-12-05 Thread Laszlo Pinter (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16988597#comment-16988597
 ] 

Laszlo Pinter commented on HIVE-22473:
--

[~aditya-shah] Please open a new jira, and describe the details. Thanks

> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch, 
> HIVE-22473.03.patch, HIVE-22473.04.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:567) 
> ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:801)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  ~[?:1.8.0_211] at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  ~[?:1.8.0_211] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]Caused 
> by: java.io.IOException: java.lang.RuntimeException: ORC split generation 
> failed with exception: java.lang.StringIndexOutOfBoundsException: String 
> index out of range: -1 at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:638)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:545) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:151) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2142) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.getResults(ReExecDriver.java:241)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:476)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] ... 13 moreCaused by: 
> java.lang.RuntimeException: ORC split generation failed with exception: 
> java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at 
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.generateSplitsInfo(OrcInputFormat.java:1929)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getSplits(OrcInputFormat.java:2016)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-12-04 Thread Aditya Shah (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16988522#comment-16988522
 ] 

Aditya Shah commented on HIVE-22473:


[~lpinter], I faced the same issue after the fix. I think, we should add a 
similar check for table to be acid in BISplitStategy's getSplit function?

> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch, 
> HIVE-22473.03.patch, HIVE-22473.04.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:567) 
> ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:801)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  ~[?:1.8.0_211] at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  ~[?:1.8.0_211] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]Caused 
> by: java.io.IOException: java.lang.RuntimeException: ORC split generation 
> failed with exception: java.lang.StringIndexOutOfBoundsException: String 
> index out of range: -1 at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:638)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:545) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:151) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2142) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.getResults(ReExecDriver.java:241)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:476)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] ... 13 moreCaused by: 
> java.lang.RuntimeException: ORC split generation failed with exception: 
> java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at 
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.generateSplitsInfo(OrcInputFormat.java:1929)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getSplits(OrcInputForm

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-10 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971257#comment-16971257
 ] 

Hive QA commented on HIVE-22473:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12985475/HIVE-22473.04.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:green}SUCCESS:{color} +1 due to 17706 tests passed

Test results: 
https://builds.apache.org/job/PreCommit-HIVE-Build/19373/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19373/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19373/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12985475 - PreCommit-HIVE-Build

> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch, 
> HIVE-22473.03.patch, HIVE-22473.04.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:567) 
> ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:801)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  ~[?:1.8.0_211] at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  ~[?:1.8.0_211] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]Caused 
> by: java.io.IOException: java.lang.RuntimeException: ORC split generation 
> failed with exception: java.lang.StringIndexOutOfBoundsException: String 
> index out of range: -1 at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:638)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:545) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:151) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.Driver.getResults(Driver.jav

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-10 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971255#comment-16971255
 ] 

Hive QA commented on HIVE-22473:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  9m 
 2s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
6s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
44s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
4s{color} | {color:blue} ql in master has 1550 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
1s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
32s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
43s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
14s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
1s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
14s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 25m 17s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-19373/dev-support/hive-personality.sh
 |
| git revision | master / a304e3c |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.1 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-19373/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch, 
> HIVE-22473.03.patch, HIVE-22473.04.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-10 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971245#comment-16971245
 ] 

Hive QA commented on HIVE-22473:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12985473/HIVE-22473.03.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 17678 tests 
executed
*Failed tests:*
{noformat}
TestMiniLlapLocalCliDriver - did not produce a TEST-*.xml file (likely timed 
out) (batchId=187)

[vector_case_when_1.q,tez_nway_join.q,bucket_map_join_tez1.q,vector_multi_insert.q,insert_update_delete.q,schema_evol_orc_nonvec_part_all_primitive_llap_io.q,temp_table.q,external_jdbc_table_partition.q,cte_1.q,autoColumnStats_2.q,partition_pruning.q,reopt_semijoin.q,orc_merge8.q,orc_merge_incompat2.q,vector_outer_join4.q,materialized_view_partitioned.q,orc_merge7.q,bucketpruning1.q,schema_evol_orc_acidvec_table.q,vector_grouping_sets.q,vector_outer_join5.q,schema_evol_orc_acidvec_part_update_llap_io.q,groupby_groupingset_bug.q,bucketmapjoin1.q,vector_udf_inline.q,load_dyn_part1.q,results_cache_temptable.q,groupby_rollup_empty2.q,auto_sortmerge_join_11.q,orc_merge_incompat_writer_version.q]
org.apache.hadoop.hive.metastore.TestHiveMetaStoreAlterColumnPar.org.apache.hadoop.hive.metastore.TestHiveMetaStoreAlterColumnPar
 (batchId=248)
org.apache.hadoop.hive.ql.TestWarehouseExternalDir.org.apache.hadoop.hive.ql.TestWarehouseExternalDir
 (batchId=276)
org.apache.hadoop.hive.ql.TestWarehouseExternalDir.testExternalDefaultPaths 
(batchId=276)
{noformat}

Test results: 
https://builds.apache.org/job/PreCommit-HIVE-Build/19372/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19372/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19372/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 4 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12985473 - PreCommit-HIVE-Build

> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch, 
> HIVE-22473.03.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:567) 
> ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:801)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.TBaseProcessor.process(TBaseProcesso

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-10 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971238#comment-16971238
 ] 

Hive QA commented on HIVE-22473:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  9m 
12s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
43s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
7s{color} | {color:blue} ql in master has 1550 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
0s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
35s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
9s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
9s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
41s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
21s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
5s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
15s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 25m 47s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-19372/dev-support/hive-personality.sh
 |
| git revision | master / a304e3c |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.1 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-19372/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch, 
> HIVE-22473.03.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetc

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-10 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971220#comment-16971220
 ] 

Hive QA commented on HIVE-22473:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12985470/HIVE-22473.02.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 17706 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb_schq] 
(batchId=177)
org.apache.hadoop.hive.schq.TestScheduledQueryIntegration.testScheduledQueryExecutionImpersonation
 (batchId=279)
{noformat}

Test results: 
https://builds.apache.org/job/PreCommit-HIVE-Build/19371/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19371/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19371/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12985470 - PreCommit-HIVE-Build

> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:567) 
> ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:801)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  ~[?:1.8.0_211] at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  ~[?:1.8.0_211] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]Caused 
> by: java.io.IOException: java.lang.RuntimeException: ORC split generation 
> failed with exception: java.lang.StringIndexOutOfBoundsException: String 
> index out of range: -1 at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:638)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.e

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-10 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971193#comment-16971193
 ] 

Hive QA commented on HIVE-22473:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  8m 
58s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
11s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
40s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
2s{color} | {color:blue} ql in master has 1550 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
4s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
30s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m 
10s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m 
10s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
43s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
15s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
4s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
16s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 25m 36s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-19371/dev-support/hive-personality.sh
 |
| git revision | master / a304e3c |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.1 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-19371/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch, HIVE-22473.02.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-08 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16970553#comment-16970553
 ] 

Hive QA commented on HIVE-22473:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12985355/HIVE-22473.01.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 17668 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.ql.TestTxnNoBucketsVectorized.testCtasPartitioned 
(batchId=336)
org.apache.hive.jdbc.TestJdbcWithMiniHS2.testConcurrentLineage (batchId=288)
{noformat}

Test results: 
https://builds.apache.org/job/PreCommit-HIVE-Build/19355/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19355/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19355/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12985355 - PreCommit-HIVE-Build

> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:567) 
> ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:801)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  ~[?:1.8.0_211] at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  ~[?:1.8.0_211] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]Caused 
> by: java.io.IOException: java.lang.RuntimeException: ORC split generation 
> failed with exception: java.lang.StringIndexOutOfBoundsException: String 
> index out of range: -1 at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:638)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:545) 
> ~[hive-exec-

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-08 Thread Hive QA (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16970528#comment-16970528
 ] 

Hive QA commented on HIVE-22473:


| (/) *{color:green}+1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} @author {color} | {color:green}  0m  
0s{color} | {color:green} The patch does not contain any @author tags. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  8m 
56s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
40s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue}  4m  
4s{color} | {color:blue} ql in master has 1549 extant Findbugs warnings. 
{color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
4s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green}  1m 
31s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green}  1m  
7s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green}  0m 
41s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green}  0m 
 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} findbugs {color} | {color:green}  4m 
18s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green}  1m  
2s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green}  0m 
15s{color} | {color:green} The patch does not generate ASF License warnings. 
{color} |
| {color:black}{color} | {color:black} {color} | {color:black} 25m 17s{color} | 
{color:black} {color} |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests |  asflicense  javac  javadoc  findbugs  checkstyle  compile  |
| uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 
3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux |
| Build tool | maven |
| Personality | 
/data/hiveptest/working/yetus_PreCommit-HIVE-Build-19355/dev-support/hive-personality.sh
 |
| git revision | master / 3b4c2fe |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.1 |
| modules | C: ql U: ql |
| Console output | 
http://104.198.109.242/logs//PreCommit-HIVE-Build-19355/yetus.txt |
| Powered by | Apache Yetushttp://yetus.apache.org |


This message was automatically generated.



> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

2019-11-08 Thread Peter Vary (Jira)



[ 
https://issues.apache.org/jira/browse/HIVE-22473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16970306#comment-16970306
 ] 

Peter Vary commented on HIVE-22473:
---

+1 pending tests

> Avoid reading table as ACID when table name is starting with "delta", but 
> table is not transactional
> 
>
> Key: HIVE-22473
> URL: https://issues.apache.org/jira/browse/HIVE-22473
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Reporter: Laszlo Pinter
>Assignee: Laszlo Pinter
>Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22473.01.patch
>
>
> {code:sql}
> create table delta_result (a int) stored as orc 
> tblproperties('transactional'='false');
> insert into delta_result select 1;
> select * from delta_result;
> {code}
>  The above query will result in the following exception:
> 2019-11-08T13:49:05,780  WARN [HiveServer2-Handler-Pool: Thread-7906] 
> thrift.ThriftCLIService: Error fetching results:2019-11-08T13:49:05,780  WARN 
> [HiveServer2-Handler-Pool: Thread-7906] thrift.ThriftCLIService: Error 
> fetching results:org.apache.hive.service.cli.HiveSQLException: 
> java.io.IOException: java.lang.RuntimeException: ORC split generation failed 
> with exception: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: -1 at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:481)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:331)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:946)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:567) 
> ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:801)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1837)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1822)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>  ~[?:1.8.0_211] at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>  ~[?:1.8.0_211] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_211]Caused 
> by: java.io.IOException: java.lang.RuntimeException: ORC split generation 
> failed with exception: java.lang.StringIndexOutOfBoundsException: String 
> index out of range: -1 at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:638)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:545) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:151) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2142) 
> ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.getResults(ReExecDriver.java:241)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:476)
>  ~[hive-service-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] ... 13 moreCaused by: 
> java.lang.RuntimeException: ORC split generation failed with exception: 
> java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at 
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.generateSplitsInfo(OrcInputFormat.java:1929)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getSplits(OrcInputFormat.java:2016)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.generateWrappedSplits(FetchOperator.java:461)
>  ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

[jira] [Commented] (HIVE-22473) Avoid reading table as ACID when table name is starting with "delta", but table is not transactional

11 matches

Site Navigation

Mail list logo

Footer information