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 2021/01/26 00:57:00 UTC
[jira] [Work logged] (HIVE-24343) Table partition operations
(create, drop, select) fail when the number of partitions is greater than
32767 (signed int)
[ https://issues.apache.org/jira/browse/HIVE-24343?focusedWorklogId=541416&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-541416 ]
ASF GitHub Bot logged work on HIVE-24343:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 26/Jan/21 00:56
Start Date: 26/Jan/21 00:56
Worklog Time Spent: 10m
Work Description: github-actions[bot] commented on pull request #1640:
URL: https://github.com/apache/hive/pull/1640#issuecomment-767209581
This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
Feel free to reach out on the dev@hive.apache.org list if the patch is in need of reviews.
----------------------------------------------------------------
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: 541416)
Time Spent: 1.5h (was: 1h 20m)
> Table partition operations (create, drop, select) fail when the number of partitions is greater than 32767 (signed int)
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-24343
> URL: https://issues.apache.org/jira/browse/HIVE-24343
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Reporter: Narayanan Venkateswaran
> Assignee: Narayanan Venkateswaran
> Priority: Minor
> Labels: pull-request-available
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> The table partition operations - create, drop, select access the underlying relation database using JDO, which internally routes the operations through the JDBC driver. Most of the underlying JDBC driver implementations place a limit on the number of parameters that can be passed through a statement implementation. The limitations are as follows,
> postgreSQL - 32767
> (https://www.postgresql.org/message-id/16832734.post%40talk.nabble.com)
> MySQL - 32767 - 2 Byte Integer - num of params
> (https://dev.mysql.com/doc/internals/en/com-stmt-prepare-response.html#packet-COM_STMT_PREPARE_OK)
> Oracle - 32767 -
> https://www.jooq.org/doc/3.12/manual/sql-building/dsl-context/custom-settings/settings-inline-threshold/
> Derby - 32767 - stored in an unsinged integer - Note the Prepared
> Statement implementation here -
> [https://svn.apache.org/repos/asf/db/derby/code/branches/10.1/java/client/org/apache/derby/client/am/PreparedStatement.java]
>
> These limits should be taken into account when querying the underlying metastore.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)