Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-27405

Throw out the detail error Invalid partition name to the clients

    XMLWordPrintableJSON

Details

    Description

      When try to MSCK TABLE, if there is a directory that doesn't match the partition format, the query fails. However, it doesn't thrown out the detail error information to the client.

       

      > MSCK table db_1.table_1;
Error: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.ddl.DDLTask (state=08S01,code=1)

      From the logs, we are able to see the detailed error which helps the customer to fix the incorrect partition name withour rasing a case.

      2023-04-11 12:42:18,012 WARN org.apache.hadoop.hive.metastore.Msck: [6fd73a49-32eb-48e3-907e-00a1a71979e8 HiveServer2-Handler-Pool: Thread-30852428]: Failed to run metacheck:
org.apache.hadoop.hive.metastore.utils.MetastoreException: Invalid partition name hdfs://warehouse/db_1.db/table_1/part

      This error has to be printed out to the client side, so that users can fix it by themselves before checking logs. 

      Attachments

        Issue Links

          links to

          Web Link GitHub Pull Request #5087

          Activity

            People

              tarak271 Taraka Rama Rao Lethavadla
              tarak271 Taraka Rama Rao Lethavadla
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: