[
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:
us...@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)
