[jira] [Created] (HIVE-11255) get_table_objects_by_name() in HiveMetaStore.java needs to retrieve table objects in multiple batches

["Aihua Xu (JIRA)" <ji...@apache.org>]

Aihua Xu created HIVE-11255:
-------------------------------

             Summary: 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


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)