[jira] [Updated] (HIVE-28298) TestQueryShutdownHooks to run on Tez

2024-06-03 Thread Jira


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

László Bodor updated HIVE-28298:

Description: 
this test got stuck while running in the scope of HIVE-27972, need to check

jstack showed stacks like:
{code}
"HiveServer2-Background-Pool: Thread-155" #155 prio=5 os_prio=31 
tid=0x7fa59f5e4800 nid=0x8027 waiting for monitor entry [0x700010ace000]
   java.lang.Thread.State: BLOCKED (on object monitor)
at 
org.apache.hadoop.hive.ql.exec.tez.TezTask$SyncDagClient.tryKillDAG(TezTask.java:870)
- waiting to lock <0x0007be5c98f8> (a 
org.apache.tez.dag.api.client.DAGClientImplLocal)
at 
org.apache.hadoop.hive.ql.exec.tez.monitoring.TezJobMonitor.monitorExecution(TezJobMonitor.java:278)
at org.apache.hadoop.hive.ql.exec.tez.TezTask.execute(TezTask.java:271)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:214)
at 
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:105)
at org.apache.hadoop.hive.ql.Executor.launchTask(Executor.java:354)
at org.apache.hadoop.hive.ql.Executor.launchTasks(Executor.java:327)
at org.apache.hadoop.hive.ql.Executor.runTasks(Executor.java:244)
at org.apache.hadoop.hive.ql.Executor.execute(Executor.java:105)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:367)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:205)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:154)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:149)
at 
org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:185)
at 
org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:236)
at 
org.apache.hive.service.cli.operation.SQLOperation.access$500(SQLOperation.java:90)
at 
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:336)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1899)
at 
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:356)
at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)




"f7b8e319-d882-4734-b036-1bb2da4b2783 main" #1 prio=5 os_prio=31 
tid=0x7fa60e80b800 nid=0x1b03 waiting on condition [0x7e32a000]
   java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for  <0x0007be3d0578> (a 
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at 
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
at 
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
at 
org.apache.tez.dag.app.dag.impl.DAGImpl.getDAGStatus(DAGImpl.java:982)
at 
org.apache.tez.dag.api.client.DAGClientHandler.getDAGStatus(DAGClientHandler.java:73)
at org.apache.tez.client.LocalClient$2.apply(LocalClient.java:441)
at org.apache.tez.client.LocalClient$2.apply(LocalClient.java:437)
at 
org.apache.tez.dag.api.client.DAGClientImplLocal.getDAGStatusInternal(DAGClientImplLocal.java:53)
at 
org.apache.tez.dag.api.client.DAGClientImpl.getDAGStatus(DAGClientImpl.java:232)
at 
org.apache.tez.dag.api.client.DAGClientImpl._waitForCompletionWithStatusUpdates(DAGClientImpl.java:583)
at 
org.apache.tez.dag.api.client.DAGClientImpl.waitForCompletion(DAGClientImpl.java:375)
at 
org.apache.hadoop.hive.ql.exec.tez.TezTask$SyncDagClient.waitForCompletion(TezTask.java:877)
- locked <0x0007be5c98f8> (a 
org.apache.tez.dag.api.client.DAGClientImplLocal)
at 
org.apache.hadoop.hive.ql.exec.tez.TezTask.closeDagClientOnCancellation(TezTask.java:432)
at org.apache.hadoop.hive.ql.exec.tez.TezTask.shutdown(TezTask.java:805)
at org.apache.hadoop.hive.ql.TaskQueue.shutdown(TaskQueue.java:138)
- locked <0x0007be2a20b8> (a org.apache.hadoop.hive.ql.TaskQueue)
at org.apache.hadoop.hive.ql.Driver.releaseTaskQueue(Driver.java:802)
at org.apache.hadoop.hive.ql.Driver.close(Driver.java:779)
at 
org.apache.hadoop.hive.ql.reexec.ReExecDriver.close(ReExecDriver.java:268)
at 
org.apache.hive.service.cli.operation.SQLOperation.cleanup(SQLOperation.java:409)
- locked <0x0007be5994c0> (a 
org.apach

[jira] [Created] (HIVE-28298) TestQueryShutdownHooks to run on Tez

2024-06-03 Thread Jira
László Bodor created HIVE-28298:
---

 Summary: TestQueryShutdownHooks to run on Tez
 Key: HIVE-28298
 URL: https://issues.apache.org/jira/browse/HIVE-28298
 Project: Hive
  Issue Type: Sub-task
Reporter: László Bodor






--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (HIVE-28294) drop database cascade operation can skip client side filtering while fetching tables in db

2024-06-03 Thread ASF GitHub Bot (Jira)


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

ASF GitHub Bot updated HIVE-28294:
--
Labels: pull-request-available  (was: )

> drop database cascade operation can skip client side filtering while fetching 
> tables in db
> --
>
> Key: HIVE-28294
> URL: https://issues.apache.org/jira/browse/HIVE-28294
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Reporter: Sai Hemanth Gantasala
>Assignee: Sai Hemanth Gantasala
>Priority: Major
>  Labels: pull-request-available
>
> Drop database cascade operation fetches all tables in the DB, while doing so 
> we perform client-side filtering on the tables. We can avoid client-side 
> filtering as we anyway authorize on the tables in the DB for the drop 
> operation.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Work started] (HIVE-28297) Unify table pattern definition in Hive MetaStore

2024-06-03 Thread Wechar (Jira)


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

Work on HIVE-28297 started by Wechar.
-
> Unify table pattern definition in Hive MetaStore
> 
>
> Key: HIVE-28297
> URL: https://issues.apache.org/jira/browse/HIVE-28297
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Reporter: Wechar
>Assignee: Wechar
>Priority: Major
>
> *Current Situation*
> There are two cases for table pattern in Hive:
>  - Case 1: Wildcards ('*' and '|)
> It's replaced by SQL type like expressions with '%' and '_' since Hive 4.0.0, 
> details in HIVE-23359.
> DDL documents: 
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Show
>  - Case 2: Java regular expression
> It's declared in hive code:
> [https://github.com/apache/hive/blob/45867be6cb5308566e4cf16c7b4cf8081085b58c/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java#L1882-L1894],
>  and also match the jdo {{matches(String pattern)}} method: 
> [https://www.datanucleus.org/products/accessplatform/jdo/query.html]
> *Issues*
> The different definitions cause the misuse of table pattern, in some codes it 
> use * to represent match everything, while it use .* in other codes.
> The misuse would cause the wrong result because both client and server side 
> of HMS need a trick handle for '*' with code like:
> {code:java}
> patterns.split("\\|")
> pattern.replaceAll("\\*", ".*"))
> {code}
> *Action*
> We should honor the definition in HMS of Case 2, because Case 1 is just the 
> frontend of SQL, and it has been replaced.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (HIVE-28297) Unify table pattern definition in Hive MetaStore

2024-06-03 Thread Wechar (Jira)


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

Wechar updated HIVE-28297:
--
Description: 
*Current Situation*
There are two cases for table pattern in Hive:
 - Case 1: Wildcards ('*' and '|)
It's replaced by SQL type like expressions with '%' and '_' since Hive 4.0.0, 
details in HIVE-23359.
DDL documents: 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Show
 - Case 2: Java regular expression
It's declared in hive code:
[https://github.com/apache/hive/blob/45867be6cb5308566e4cf16c7b4cf8081085b58c/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java#L1882-L1894],
 and also match the jdo {{matches(String pattern)}} method: 
[https://www.datanucleus.org/products/accessplatform/jdo/query.html]

*Issues*
The different definitions cause the misuse of table pattern, in some codes it 
use * to represent match everything, while it use .* in other codes.

The misuse would cause the wrong result because both client and server side of 
HMS need a trick handle for '*' with code like:
{code:java}
patterns.split("\\|")
pattern.replaceAll("\\*", ".*"))
{code}
*Action*
We should honor the definition in HMS of Case 2, because Case 1 is just the 
frontend of SQL, and it has been replaced.

  was:
*Current Situation*
There are two cases for table pattern in Hive:
 - Case 1: Wildcards ('*' and '|)
It's replaced by SQL type like expressions with '%' and '_' since Hive 4.0.0, 
details in HIVE-23359
 - Case 2: Java regular expression
It's declared in hive code:
[https://github.com/apache/hive/blob/45867be6cb5308566e4cf16c7b4cf8081085b58c/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java#L1882-L1894],
 and also match the jdo {{matches(String pattern)}} method: 
[https://www.datanucleus.org/products/accessplatform/jdo/query.html]

*Issues*
The different definitions cause the misuse of table pattern, in some codes it 
use * to represent match everything, while it use .* in other codes.

The misuse would cause the wrong result because both client and server side of 
HMS need a trick handle for '*' with code like:

{code:java}
patterns.split("\\|")
pattern.replaceAll("\\*", ".*"))
{code}

*Action*
We should honor the definition in HMS of Case 2, because Case 1 is just the 
frontend of SQL, and it has been replaced.


> Unify table pattern definition in Hive MetaStore
> 
>
> Key: HIVE-28297
> URL: https://issues.apache.org/jira/browse/HIVE-28297
> Project: Hive
>  Issue Type: Improvement
>  Components: Hive
>Reporter: Wechar
>Assignee: Wechar
>Priority: Major
>
> *Current Situation*
> There are two cases for table pattern in Hive:
>  - Case 1: Wildcards ('*' and '|)
> It's replaced by SQL type like expressions with '%' and '_' since Hive 4.0.0, 
> details in HIVE-23359.
> DDL documents: 
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Show
>  - Case 2: Java regular expression
> It's declared in hive code:
> [https://github.com/apache/hive/blob/45867be6cb5308566e4cf16c7b4cf8081085b58c/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java#L1882-L1894],
>  and also match the jdo {{matches(String pattern)}} method: 
> [https://www.datanucleus.org/products/accessplatform/jdo/query.html]
> *Issues*
> The different definitions cause the misuse of table pattern, in some codes it 
> use * to represent match everything, while it use .* in other codes.
> The misuse would cause the wrong result because both client and server side 
> of HMS need a trick handle for '*' with code like:
> {code:java}
> patterns.split("\\|")
> pattern.replaceAll("\\*", ".*"))
> {code}
> *Action*
> We should honor the definition in HMS of Case 2, because Case 1 is just the 
> frontend of SQL, and it has been replaced.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (HIVE-28297) Unify table pattern definition in Hive MetaStore

2024-06-03 Thread Wechar (Jira)
Wechar created HIVE-28297:
-

 Summary: Unify table pattern definition in Hive MetaStore
 Key: HIVE-28297
 URL: https://issues.apache.org/jira/browse/HIVE-28297
 Project: Hive
  Issue Type: Improvement
  Components: Hive
Reporter: Wechar
Assignee: Wechar


*Current Situation*
There are two cases for table pattern in Hive:
 - Case 1: Wildcards ('*' and '|)
It's replaced by SQL type like expressions with '%' and '_' since Hive 4.0.0, 
details in HIVE-23359
 - Case 2: Java regular expression
It's declared in hive code:
[https://github.com/apache/hive/blob/45867be6cb5308566e4cf16c7b4cf8081085b58c/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java#L1882-L1894],
 and also match the jdo {{matches(String pattern)}} method: 
[https://www.datanucleus.org/products/accessplatform/jdo/query.html]

*Issues*
The different definitions cause the misuse of table pattern, in some codes it 
use * to represent match everything, while it use .* in other codes.

The misuse would cause the wrong result because both client and server side of 
HMS need a trick handle for '*' with code like:

{code:java}
patterns.split("\\|")
pattern.replaceAll("\\*", ".*"))
{code}

*Action*
We should honor the definition in HMS of Case 2, because Case 1 is just the 
frontend of SQL, and it has been replaced.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (HIVE-28181) Hive query plans display is disabled by default

2024-06-03 Thread asish kumar patra (Jira)


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

asish kumar patra reassigned HIVE-28181:


Assignee: asish kumar patra

> Hive query plans display is disabled by default
> ---
>
> Key: HIVE-28181
> URL: https://issues.apache.org/jira/browse/HIVE-28181
> Project: Hive
>  Issue Type: Sub-task
> Environment: When value of Hive config 
> 'hive.server2.webui.explain.output' is false, query plan showing is disabled 
> in Hive UI. The default value is 'false'.
>Reporter: Dmitriy Fingerman
>Assignee: asish kumar patra
>Priority: Major
> Attachments: Screen Shot 2024-04-05 at 5.18.10 PM.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (HIVE-28181) Hive query plans display is disabled by default

2024-06-03 Thread asish kumar patra (Jira)


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

asish kumar patra reassigned HIVE-28181:


Assignee: asish kumar patra

> Hive query plans display is disabled by default
> ---
>
> Key: HIVE-28181
> URL: https://issues.apache.org/jira/browse/HIVE-28181
> Project: Hive
>  Issue Type: Sub-task
> Environment: When value of Hive config 
> 'hive.server2.webui.explain.output' is false, query plan showing is disabled 
> in Hive UI. The default value is 'false'.
>Reporter: Dmitriy Fingerman
>Assignee: asish kumar patra
>Priority: Major
> Attachments: Screen Shot 2024-04-05 at 5.18.10 PM.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Assigned] (HIVE-28181) Hive query plans display is disabled by default

2024-06-03 Thread asish kumar patra (Jira)


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

asish kumar patra reassigned HIVE-28181:


Assignee: (was: asish kumar patra)

> Hive query plans display is disabled by default
> ---
>
> Key: HIVE-28181
> URL: https://issues.apache.org/jira/browse/HIVE-28181
> Project: Hive
>  Issue Type: Sub-task
> Environment: When value of Hive config 
> 'hive.server2.webui.explain.output' is false, query plan showing is disabled 
> in Hive UI. The default value is 'false'.
>Reporter: Dmitriy Fingerman
>Priority: Major
> Attachments: Screen Shot 2024-04-05 at 5.18.10 PM.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (HIVE-28276) Iceberg: Make Iceberg split threads configurable when table scanning

2024-06-03 Thread Denys Kuzmenko (Jira)


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

Denys Kuzmenko commented on HIVE-28276:
---

Merged to master
[~zhangbutao] thanks for the patch and [~ayushsaxena] for the review!

> Iceberg: Make Iceberg split threads configurable when table scanning
> 
>
> Key: HIVE-28276
> URL: https://issues.apache.org/jira/browse/HIVE-28276
> Project: Hive
>  Issue Type: Improvement
>  Components: Iceberg integration
>Reporter: Butao Zhang
>Assignee: Butao Zhang
>Priority: Major
>  Labels: pull-request-available
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Resolved] (HIVE-28276) Iceberg: Make Iceberg split threads configurable when table scanning

2024-06-03 Thread Denys Kuzmenko (Jira)


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

Denys Kuzmenko resolved HIVE-28276.
---
Fix Version/s: 4.1.0
   Resolution: Fixed

> Iceberg: Make Iceberg split threads configurable when table scanning
> 
>
> Key: HIVE-28276
> URL: https://issues.apache.org/jira/browse/HIVE-28276
> Project: Hive
>  Issue Type: Improvement
>  Components: Iceberg integration
>Reporter: Butao Zhang
>Assignee: Butao Zhang
>Priority: Major
>  Labels: pull-request-available
> Fix For: 4.1.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Created] (HIVE-28296) TestGracefulStopHS2 to run on Tez

2024-06-03 Thread Jira
László Bodor created HIVE-28296:
---

 Summary: TestGracefulStopHS2 to run on Tez
 Key: HIVE-28296
 URL: https://issues.apache.org/jira/browse/HIVE-28296
 Project: Hive
  Issue Type: Sub-task
Reporter: László Bodor






--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Updated] (HIVE-28254) CBO (Calcite Return Path): Multiple DISTINCT leads to wrong results

2024-06-03 Thread Krisztian Kasa (Jira)


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

Krisztian Kasa updated HIVE-28254:
--
Parent: HIVE-9132
Issue Type: Sub-task  (was: Bug)

> CBO (Calcite Return Path): Multiple DISTINCT leads to wrong results
> ---
>
> Key: HIVE-28254
> URL: https://issues.apache.org/jira/browse/HIVE-28254
> Project: Hive
>  Issue Type: Sub-task
>  Components: CBO
>Affects Versions: 4.0.0
>Reporter: Shohei Okumiya
>Assignee: Shohei Okumiya
>Priority: Major
>  Labels: hive-4.0.1-must, pull-request-available
>
> CBO return path can build incorrect GroupByOperator when multiple 
> aggregations with DISTINCT are involved.
> This is an example.
> {code:java}
> CREATE TABLE test (col1 INT, col2 INT);
> INSERT INTO test VALUES (1, 100), (2, 200), (2, 200), (3, 300);
> set hive.cbo.returnpath.hiveop=true;
> set hive.map.aggr=false;
> SELECT
>   SUM(DISTINCT col1),
>   COUNT(DISTINCT col1),
>   SUM(DISTINCT col2),
>   SUM(col2)
> FROM test;{code}
> The last column should be 800. But the SUM refers to col1 and the actual 
> result is 8.
> {code:java}
> +--+--+--+--+
> | _c0  | _c1  | _c2  | _c3  |
> +--+--+--+--+
> | 6    | 3    | 600  | 8    |
> +--+--+--+--+ {code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Resolved] (HIVE-28285) Exception when querying JDBC tables with Hive/DB column types mismatch

2024-06-03 Thread Stamatis Zampetakis (Jira)


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

Stamatis Zampetakis resolved HIVE-28285.

Fix Version/s: 4.1.0
   Resolution: Fixed

Fixed in 
[https://github.com/apache/hive/commit/07cc9c3faebf790284ed0b3b2811f83394575ff5]

 

Thanks for the review [~dengzh] !

> Exception when querying JDBC tables with Hive/DB column types mismatch
> --
>
> Key: HIVE-28285
> URL: https://issues.apache.org/jira/browse/HIVE-28285
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 4.0.0
>Reporter: Stamatis Zampetakis
>Assignee: Stamatis Zampetakis
>Priority: Major
>  Labels: pull-request-available
> Fix For: 4.1.0
>
>
> Queries over JDBC tables fail at runtime when the following conditions hold:
>  # there is a mismatch between the Hive type and the database type for some 
> columns
>  # CBO is not used
> CBO may not be used when compiling the query for various reasons:
>  * CBO is explicitly disabled (via hive.cbo.enable property)
>  * Query explicitly not supported in CBO (e.g., contains DISTRIBUTE BY clause)
>  * Problem/bug in compilation that will skip CBO execution
> The examples below demonstrate the problem with Postgres but the problem 
> itself is not database specific (although different errors may pop up 
> depending on the underlying database). Different type mappings may also lead 
> to different errors.
> h3. Map Postgres DATE to Hive TIMESTAMP
> +Postgres+
> {code:sql}
> create table date_table (cdate date);
> insert into date_table values ('2024-05-29');
> {code}
> +Hive+
> {code:sql}
> CREATE TABLE h_type_table (cdate timestamp)
> STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler'
> TBLPROPERTIES (
> "hive.sql.database.type" = "POSTGRES",
> "hive.sql.jdbc.driver" = "org.postgresql.Driver",
> "hive.sql.jdbc.url" = "jdbc:postgresql://...",
> "hive.sql.dbcp.username" = "user",
> "hive.sql.dbcp.password" = "pwd",
> "hive.sql.table" = "date_table"
> );
> {code}
> +Hive Result (CBO on)+
> |2024-05-29 00:00:00|
> +Error (CBO off)+
> {noformat}
>  java.lang.RuntimeException: java.io.IOException: 
> java.lang.IllegalArgumentException: Cannot create timestamp, parsing error 
> 2024-05-29
>   at 
> org.apache.hadoop.hive.ql.exec.FetchTask.executeInner(FetchTask.java:210)
>   at org.apache.hadoop.hive.ql.exec.FetchTask.execute(FetchTask.java:95)
>   at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:212)
>   at org.apache.hadoop.hive.ql.Driver.run(Driver.java:154)
>   at org.apache.hadoop.hive.ql.Driver.run(Driver.java:149)
>   at 
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:185)
>   at 
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:230)
>   at 
> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:257)
>   at org.apache.hadoop.hive.cli.CliDriver.processCmd1(CliDriver.java:201)
>   at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:127)
>   at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:425)
>   at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:356)
>   at 
> org.apache.hadoop.hive.ql.QTestUtil.executeClientInternal(QTestUtil.java:732)
>   at org.apache.hadoop.hive.ql.QTestUtil.executeClient(QTestUtil.java:702)
>   at 
> org.apache.hadoop.hive.cli.control.CoreCliDriver.runTest(CoreCliDriver.java:116)
>   at 
> org.apache.hadoop.hive.cli.control.CliAdapter.runTest(CliAdapter.java:157)
>   at 
> org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver(TestMiniLlapLocalCliDriver.java:62)
> Caused by: java.io.IOException: java.lang.IllegalArgumentException: Cannot 
> create timestamp, parsing error 2024-05-29
>   at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:628)
>   at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:535)
>   at 
> org.apache.hadoop.hive.ql.exec.FetchTask.executeInner(FetchTask.java:194)
>   ... 55 more
> Caused by: java.lang.IllegalArgumentException: Cannot create timestamp, 
> parsing error 2024-05-29
>   at 
> org.apache.hadoop.hive.common.type.Timestamp.valueOf(Timestamp.java:194)
>   at 
> org.apache.hive.storage.jdbc.JdbcSerDe.deserialize(JdbcSerDe.java:314)
>   at 
> org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:609)
>   ... 57 more
> Caused by: java.time.format.DateTimeParseException: Text '2024-05-29' could 
> not be parsed: Unable to obtain LocalDateTime from TemporalAccessor: {},ISO 
> resolved to 2024-05-29 of type java.time.format.Parsed
>   at 
> java.time.format.DateTimeFormatter.createE

[jira] [Comment Edited] (HIVE-28293) TestGracefulStopHS2 runs too long

2024-06-03 Thread Zhihua Deng (Jira)


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

Zhihua Deng edited comment on HIVE-28293 at 6/3/24 8:18 AM:


Sounds like the query is still running on cancellation until it completes(Tez) 
in this case, or could we remove this line?

[https://github.com/apache/hive/blob/8c90ec0ce576d6319470f7dc4dd27daebb654dec/ql/src/java/org/apache/hadoop/hive/ql/exec/tez/TezTask.java#L420]


was (Author: dengzh):
Sounds like the query is still running on cancellation until it completes(Tez) 
in this case, or could we remove this line?

[https://github.com/apache/hive/blob/8c90ec0ce576d6319470f7dc4dd27daebb654dec/ql/src/java/org/apache/hadoop/hive/ql/exec/tez/TezTask.java#L420]

 

 

> TestGracefulStopHS2 runs too long
> -
>
> Key: HIVE-28293
> URL: https://issues.apache.org/jira/browse/HIVE-28293
> Project: Hive
>  Issue Type: Bug
>Reporter: László Bodor
>Assignee: Zhihua Deng
>Priority: Major
>  Labels: newbie
>
> it tests whether long queries are finished successfully in the event of a 
> graceful shutdown, however 10 minutes seems to be too long: 
> https://github.com/apache/hive/blob/8c90ec0ce576d6319470f7dc4dd27daebb654dec/itests/hive-unit/src/test/java/org/apache/hive/service/server/TestGracefulStopHS2.java#L85
> I'm pretty sure we can validate this in a few minutes
> {code}
> [INFO] ---
> [INFO]  T E S T S
> [INFO] ---
> [INFO] Running org.apache.hive.service.server.TestGracefulStopHS2
> [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
> 1,225.833 s - in org.apache.hive.service.server.TestGracefulStopHS2
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (HIVE-28293) TestGracefulStopHS2 runs too long

2024-06-03 Thread Zhihua Deng (Jira)


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

Zhihua Deng commented on HIVE-28293:


Sounds like the query is still running on cancellation until it completes(Tez) 
in this case, or could we remove this line?

[https://github.com/apache/hive/blob/8c90ec0ce576d6319470f7dc4dd27daebb654dec/ql/src/java/org/apache/hadoop/hive/ql/exec/tez/TezTask.java#L420]

 

 

> TestGracefulStopHS2 runs too long
> -
>
> Key: HIVE-28293
> URL: https://issues.apache.org/jira/browse/HIVE-28293
> Project: Hive
>  Issue Type: Bug
>Reporter: László Bodor
>Assignee: Zhihua Deng
>Priority: Major
>  Labels: newbie
>
> it tests whether long queries are finished successfully in the event of a 
> graceful shutdown, however 10 minutes seems to be too long: 
> https://github.com/apache/hive/blob/8c90ec0ce576d6319470f7dc4dd27daebb654dec/itests/hive-unit/src/test/java/org/apache/hive/service/server/TestGracefulStopHS2.java#L85
> I'm pretty sure we can validate this in a few minutes
> {code}
> [INFO] ---
> [INFO]  T E S T S
> [INFO] ---
> [INFO] Running org.apache.hive.service.server.TestGracefulStopHS2
> [INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 
> 1,225.833 s - in org.apache.hive.service.server.TestGracefulStopHS2
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)