You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2020/11/30 21:23:00 UTC
[jira] [Work logged] (HIVE-24453) Direct SQL error when parsing
create_time value for database
[ https://issues.apache.org/jira/browse/HIVE-24453?focusedWorklogId=518130&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-518130 ]
ASF GitHub Bot logged work on HIVE-24453:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 30/Nov/20 21:22
Start Date: 30/Nov/20 21:22
Worklog Time Spent: 10m
Work Description: jcamachor opened a new pull request #1719:
URL: https://github.com/apache/hive/pull/1719
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 518130)
Remaining Estimate: 0h
Time Spent: 10m
> Direct SQL error when parsing create_time value for database
> ------------------------------------------------------------
>
> Key: HIVE-24453
> URL: https://issues.apache.org/jira/browse/HIVE-24453
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> HIVE-21077 introduced a {{create_time}} field for {{DBS}} table in HMS. Although the value for that field is always set after that patch, the value could be null if the database was created before the feature went in. DirectSQL should check for null value before parsing the integer, otherwise we hit an exception and fallback to ORM path:
> {code}
> 2020-11-28 09:06:05,414 WARN org.apache.hadoop.hive.metastore.ObjectStore: [pool-8-thread-194]: Falling back to ORM path due to direct SQL failure (this is not an error): null at org.apache.hadoop.hive.metastore.MetastoreDirectSqlUtils.extractSqlInt(MetastoreDirectSqlUtils.java:251) at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getDatabase(MetaStoreDirectSql.java:420) at org.apache.hadoop.hive.metastore.ObjectStore$1.getSqlResult(ObjectStore.java:839)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)