hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11255) get_table_objects_by_name() in HiveMetaStore.java needs to retrieve table objects in multiple batches
Date Tue, 14 Jul 2015 21:14:05 GMT

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

Sergey Shelukhin commented on HIVE-11255:
-----------------------------------------

What is the callstack for the exception you are getting? If it's in directsql, the problem
is better solved there. It's already fixed in partition retrieval code

> get_table_objects_by_name() in HiveMetaStore.java needs to retrieve table objects in
multiple batches 
> ------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-11255
>                 URL: https://issues.apache.org/jira/browse/HIVE-11255
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema
>    Affects Versions: 2.0.0
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>         Attachments: HIVE-11255.patch
>
>
> get_table_objects_by_name() function in HiveMetaStore.java right now will pass all the
tables of one database to ObjectStore to retrieve the table objects, which will cause {{java.sql.SQLSyntaxErrorException:
ORA-01795: maximum number of expressions in a list is 1000}} in Oracle database. We should
break the table list into multiple sublists similar as the drop database op.



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

Mime
View raw message