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 2023/04/03 00:21:00 UTC
[jira] [Work logged] (HIVE-26953) Exception in alter partitions with oracle db when partitions are more than 1000. Exception: ORA-01795: maximum number of expressions in a list is 1000
[ https://issues.apache.org/jira/browse/HIVE-26953?focusedWorklogId=854371&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-854371 ]
ASF GitHub Bot logged work on HIVE-26953:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 03/Apr/23 00:20
Start Date: 03/Apr/23 00:20
Worklog Time Spent: 10m
Work Description: github-actions[bot] closed pull request #3966: HIVE-26953: Exception in alter partitions with oracle db when partitions are more than 1000
URL: https://github.com/apache/hive/pull/3966
Issue Time Tracking
-------------------
Worklog Id: (was: 854371)
Time Spent: 1h 10m (was: 1h)
> Exception in alter partitions with oracle db when partitions are more than 1000. Exception: ORA-01795: maximum number of expressions in a list is 1000
> ------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-26953
> URL: https://issues.apache.org/jira/browse/HIVE-26953
> Project: Hive
> Issue Type: Bug
> Reporter: Venugopal Reddy K
> Assignee: Venugopal Reddy K
> Priority: Major
> Labels: pull-request-available
> Attachments: partdata1001
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> *[Description]*
> Alter partitions with oracle db throws exception when the number of partitions are more than 1000. Oracle db has limitation on number of values passed in the IN operator. It cannot exceed 1000.
> *[Steps to reproduce]*
> Create stage table, load data that has 1000+ rows into stage table, create partition table and load data into the table from the stage table. data file[^partdata1001] is attached below.
>
> {code:java}
> 0: jdbc:hive2://localhost:10000> create database mydb;
> 0: jdbc:hive2://localhost:10000> use mydb;
>
> 0: jdbc:hive2://localhost:10000> create table stage(sr int, st string, name string) row format delimited fields terminated by '\t' stored as textfile;
>
> 0: jdbc:hive2://localhost:10000> load data local inpath 'partdata1001' into table stage;
>
> 0: jdbc:hive2://localhost:10000> create table dynpart(num int, name string) partitioned by (category string) row format delimited fields terminated by '\t' stored as textfile;
>
> 0: jdbc:hive2://localhost:10000> insert into dynpart select * from stage;
> {code}
>
> *Alter partition throws exception(ORA-01795: maximum number of expressions in a list is 1000) during BasicStatsTask.aggregateStats. This issue occurs with oracle db due to its limitation of number of values in the IN operator.*
> *[Exception Stack]*
>
> {code:java}
> NestedThrowables:
> java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
> at org.apache.hadoop.hive.ql.metadata.Hive.alterPartitions(Hive.java:1145)
> at org.apache.hadoop.hive.ql.stats.BasicStatsTask.aggregateStats(BasicStatsTask.java:380)
> at org.apache.hadoop.hive.ql.stats.BasicStatsTask.process(BasicStatsTask.java:108)
> at org.apache.hadoop.hive.ql.exec.StatsTask.execute(StatsTask.java:107)
> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:214)
> at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:105)
> at org.apache.hadoop.hive.ql.Executor.launchTask(Executor.java:354)
> at org.apache.hadoop.hive.ql.Executor.launchTasks(Executor.java:327)
> at org.apache.hadoop.hive.ql.Executor.runTasks(Executor.java:244)
> at org.apache.hadoop.hive.ql.Executor.execute(Executor.java:105)
> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:370)
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:205)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:154)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:149)
> at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:185)
> at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:236)
> at org.apache.hive.service.cli.operation.SQLOperation.access$500(SQLOperation.java:90)
> at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:340)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:422)
> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1682)
> at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:360)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: MetaException(message:javax.jdo.JDOException: Exception thrown when executing query : SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartition' AS DN_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.PART_NAME,A0.WRITE_ID,A0.PART_ID FROM PARTITIONS A0 LEFT OUTER JOIN TBLS B0 ON A0.TBL_ID = B0.TBL_ID LEFT OUTER JOIN DBS C0 ON B0.DB_ID = C0.DB_ID WHERE B0.TBL_NAME = ? AND C0."NAME" = ? AND A0.PART_NAME IN('category=100','category=1000','category=1001','category=101','category=102','category=103','category=104','category=105','category=106','category=107','category=108','category=109','category=110','category=111','category=112','category=113','category=114','category=115','category=116','category=117','category=118','category=119','category=120','category=121','category=122','category=123','category=124','category=125','category=126','category=127','category=128','category=129','category=130','category=131','category=132','category=133','category=134','category=135','category=136','category=137','category=138','category=139','category=140','category=141','category=142','category=143','category=144','category=145','category=146','category=147','category=148','category=149','category=150','category=151','category=152','category=153','category=154','category=155','category=156','category=157','category=158','category=159','category=160','category=161','category=162','category=163','category=164','category=165','category=166','category=167','category=168','category=169','category=170','category=171','category=172','category=173','category=174','category=175','category=176','category=177','category=178','category=179','category=180','category=181','category=182','category=183','category=184','category=185','category=186','category=187','category=188','category=189','category=190','category=191','category=192','category=193','category=194','category=195','category=196','category=197','category=198','category=199','category=300','category=301','category=302','category=303','category=304','category=305','category=306','category=307','category=308','category=309','category=310','category=311','category=312','category=313','category=314','category=315','category=316','category=317','category=318','category=319','category=320','category=321','category=322','category=323','category=324','category=325','category=326','category=327','category=328','category=329','category=330','category=331','category=332','category=333','category=334','category=335','category=336','category=337','category=338','category=339','category=340','category=341','category=342','category=343','category=344','category=345','category=346','category=347','category=348','category=349','category=350','category=351','category=352','category=353','category=354','category=355','category=356','category=357','category=358','category=359','category=360','category=361','category=362','category=363','category=364','category=365','category=366','category=367','category=368','category=369','category=370','category=371','category=372','category=373','category=374','category=375','category=376','category=377','category=378','category=379','category=380','category=381','category=382','category=383','category=384','category=385','category=386','category=387','category=388','category=389','category=390','category=391','category=392','category=393','category=394','category=395','category=396','category=397','category=398','category=399','category=540','category=541','category=542','category=543','category=544','category=545','category=546','category=547','category=548','category=549','category=550','category=551','category=552','category=553','category=554','category=555','category=556','category=557','category=558','category=559','category=560','category=561','category=562','category=563','category=564','category=565','category=566','category=567','category=568','category=569','category=570','category=571','category=572','category=573','category=574','category=575','category=576','category=577','category=578','category=579','category=580','category=581','category=582','category=583','category=584','category=585','category=586','category=587','category=588','category=589','category=590','category=591','category=592','category=593','category=594','category=595','category=596','category=597','category=598','category=599','category=780','category=781','category=782','category=783','category=784','category=785','category=786','category=787','category=788','category=789','category=790','category=791','category=792','category=793','category=794','category=795','category=796','category=797','category=798','category=799','category=820','category=821','category=822','category=823','category=824','category=825','category=826','category=827','category=828','category=829','category=832','category=833','category=834','category=835','category=836','category=837','category=838','category=839','category=205','category=206','category=207','category=208','category=209','category=260','category=261','category=262','category=263','category=264','category=265','category=266','category=267','category=268','category=269','category=270','category=271','category=272','category=273','category=274','category=275','category=276','category=277','category=278','category=279','category=280','category=281','category=282','category=283','category=284','category=285','category=286','category=287','category=288','category=289','category=290','category=291','category=292','category=293','category=294','category=295','category=296','category=297','category=298','category=299','category=400','category=401','category=402','category=403','category=404','category=405','category=406','category=407','category=408','category=409','category=410','category=411','category=412','category=413','category=414','category=415','category=416','category=417','category=418','category=419','category=420','category=421','category=422','category=423','category=424','category=425','category=426','category=427','category=428','category=429','category=430','category=431','category=432','category=433','category=434','category=435','category=436','category=437','category=438','category=439','category=447','category=448','category=449','category=50','category=51','category=52','category=53','category=54','category=55','category=56','category=57','category=58','category=59','category=60','category=600','category=601','category=602','category=603','category=604','category=605','category=606','category=607','category=608','category=609','category=61','category=610','category=611','category=612','category=613','category=614','category=615','category=616','category=617','category=618','category=619','category=62','category=620','category=621','category=622','category=623','category=624','category=625','category=626','category=627','category=628','category=629','category=63','category=630','category=631','category=632','category=633','category=634','category=635','category=636','category=637','category=638','category=639','category=64','category=640','category=641','category=642','category=643','category=644','category=645','category=646','category=647','category=648','category=649','category=65','category=650','category=651','category=652','category=653','category=654','category=655','category=656','category=657','category=658','category=659','category=66','category=660','category=661','category=662','category=663','category=664','category=665','category=666','category=667','category=668','category=669','category=67','category=670','category=671','category=672','category=673','category=674','category=675','category=676','category=677','category=678','category=679','category=68','category=69','category=70','category=71','category=72','category=73','category=74','category=75','category=76','category=77','category=78','category=79','category=80','category=800','category=801','category=802','category=803','category=804','category=805','category=806','category=807','category=808','category=809','category=81','category=810','category=811','category=812','category=813','category=814','category=815','category=816','category=817','category=818','category=819','category=82','category=83','category=830','category=831','category=84','category=840','category=841','category=842','category=843','category=844','category=845','category=846','category=847','category=848','category=849','category=85','category=850','category=851','category=852','category=853','category=854','category=855','category=856','category=857','category=858','category=859','category=86','category=860','category=861','category=862','category=863','category=864','category=865','category=866','category=867','category=868','category=869','category=87','category=870','category=871','category=872','category=873','category=874','category=875','category=876','category=877','category=878','category=879','category=88','category=880','category=881','category=882','category=883','category=884','category=885','category=886','category=887','category=888','category=889','category=89','category=890','category=891','category=892','category=893','category=894','category=895','category=896','category=897','category=898','category=899','category=90','category=91','category=92','category=93','category=94','category=95','category=96','category=97','category=98','category=99','category=200','category=201','category=202','category=203','category=204','category=210','category=211','category=212','category=213','category=214','category=215','category=216','category=217','category=218','category=219','category=220','category=221','category=222','category=223','category=224','category=225','category=226','category=227','category=228','category=229','category=230','category=231','category=232','category=233','category=234','category=235','category=236','category=237','category=238','category=239','category=240','category=241','category=242','category=243','category=244','category=245','category=246','category=247','category=248','category=249','category=250','category=251','category=252','category=253','category=254','category=255','category=256','category=257','category=258','category=259','category=440','category=441','category=442','category=443','category=444','category=445','category=446','category=450','category=451','category=452','category=453','category=454','category=455','category=456','category=457','category=458','category=459','category=460','category=461','category=462','category=463','category=464','category=465','category=466','category=467','category=468','category=469','category=470','category=471','category=472','category=473','category=474','category=475','category=476','category=477','category=478','category=479','category=480','category=481','category=482','category=483','category=484','category=485','category=486','category=487','category=488','category=489','category=490','category=491','category=492','category=493','category=494','category=495','category=496','category=497','category=498','category=499','category=500','category=501','category=502','category=503','category=504','category=505','category=506','category=507','category=508','category=509','category=510','category=511','category=512','category=513','category=514','category=515','category=516','category=517','category=518','category=519','category=520','category=521','category=522','category=523','category=524','category=525','category=526','category=527','category=528','category=529','category=535','category=536','category=537','category=538','category=539','category=680','category=681','category=682','category=683','category=684','category=685','category=686','category=687','category=688','category=689','category=690','category=691','category=692','category=693','category=694','category=695','category=696','category=697','category=698','category=699','category=700','category=701','category=702','category=703','category=704','category=705','category=706','category=707','category=708','category=709','category=710','category=711','category=712','category=713','category=714','category=715','category=716','category=717','category=718','category=719','category=720','category=721','category=722','category=723','category=724','category=725','category=726','category=727','category=728','category=729','category=730','category=731','category=732','category=733','category=734','category=735','category=736','category=737','category=738','category=739','category=740','category=741','category=742','category=743','category=744','category=745','category=746','category=747','category=748','category=749','category=750','category=751','category=752','category=753','category=754','category=755','category=756','category=757','category=758','category=759','category=760','category=761','category=762','category=763','category=764','category=765','category=766','category=767','category=768','category=769','category=777','category=778','category=779','category=940','category=941','category=942','category=943','category=944','category=945','category=946','category=947','category=948','category=949','category=950','category=951','category=952','category=953','category=954','category=955','category=956','category=957','category=958','category=959','category=960','category=961','category=962','category=963','category=964','category=965','category=966','category=967','category=968','category=969','category=970','category=971','category=972','category=973','category=974','category=975','category=976','category=977','category=978','category=979','category=980','category=981','category=982','category=983','category=984','category=985','category=986','category=987','category=988','category=989','category=990','category=991','category=992','category=993','category=994','category=995','category=996','category=997','category=998','category=999','category=1','category=10','category=11','category=12','category=13','category=14','category=15','category=16','category=17','category=18','category=19','category=2','category=20','category=21','category=22','category=23','category=24','category=25','category=26','category=27','category=28','category=29','category=3','category=30','category=31','category=32','category=33','category=34','category=35','category=36','category=37','category=38','category=39','category=4','category=40','category=41','category=42','category=43','category=44','category=45','category=46','category=47','category=48','category=49','category=5','category=530','category=531','category=532','category=533','category=534','category=6','category=7','category=770','category=771','category=772','category=773','category=774','category=775','category=776','category=8','category=9','category=900','category=901','category=902','category=903','category=904','category=905','category=906','category=907','category=908','category=909','category=910','category=911','category=912','category=913','category=914','category=915','category=916','category=917','category=918','category=919','category=920','category=921','category=922','category=923','category=924','category=925','category=926','category=927','category=928','category=929','category=930','category=931','category=932','category=933','category=934','category=935','category=936','category=937','category=938','category=939') AND C0.CTLG_NAME = ?
> NestedThrowables:
> java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
> )
> at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:208)
> at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:107)
> at com.sun.proxy.$Proxy31.alter_partitions_req(Unknown Source)
> at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.alter_partitions(HiveMetaStoreClient.java:3100)
> at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.alter_partitions(SessionHiveMetaStoreClient.java:1528)
> at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.alter_partitions(HiveMetaStoreClient.java:3082)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:218)
> at com.sun.proxy.$Proxy32.alter_partitions(Unknown Source)
> at org.apache.hadoop.hive.ql.metadata.Hive.alterPartitions(Hive.java:1141)
> ... 26 more
> Caused by: javax.jdo.JDOException: Exception thrown when executing query : SELECT DISTINCT 'org.apache.hadoop.hive.metastore.model.MPartition' AS DN_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.PART_NAME,A0.WRITE_ID,A0.PART_ID FROM PARTITIONS A0 LEFT OUTER JOIN TBLS B0 ON A0.TBL_ID = B0.TBL_ID LEFT OUTER JOIN DBS C0 ON B0.DB_ID = C0.DB_ID WHERE B0.TBL_NAME = ? AND C0."NAME" = ? AND A0.PART_NAME IN('category=100','category=1000','category=1001','category=101','category=102','category=103','category=104','category=105','category=106','category=107','category=108','category=109','category=110','category=111','category=112','category=113','category=114','category=115','category=116','category=117','category=118','category=119','category=120','category=121','category=122','category=123','category=124','category=125','category=126','category=127','category=128','category=129','category=130','category=131','category=132','category=133','category=134','category=135','category=136','category=137','category=138','category=139','category=140','category=141','category=142','category=143','category=144','category=145','category=146','category=147','category=148','category=149','category=150','category=151','category=152','category=153','category=154','category=155','category=156','category=157','category=158','category=159','category=160','category=161','category=162','category=163','category=164','category=165','category=166','category=167','category=168','category=169','category=170','category=171','category=172','category=173','category=174','category=175','category=176','category=177','category=178','category=179','category=180','category=181','category=182','category=183','category=184','category=185','category=186','category=187','category=188','category=189','category=190','category=191','category=192','category=193','category=194','category=195','category=196','category=197','category=198','category=199','category=300','category=301','category=302','category=303','category=304','category=305','category=306','category=307','category=308','category=309','category=310','category=311','category=312','category=313','category=314','category=315','category=316','category=317','category=318','category=319','category=320','category=321','category=322','category=323','category=324','category=325','category=326','category=327','category=328','category=329','category=330','category=331','category=332','category=333','category=334','category=335','category=336','category=337','category=338','category=339','category=340','category=341','category=342','category=343','category=344','category=345','category=346','category=347','category=348','category=349','category=350','category=351','category=352','category=353','category=354','category=355','category=356','category=357','category=358','category=359','category=360','category=361','category=362','category=363','category=364','category=365','category=366','category=367','category=368','category=369','category=370','category=371','category=372','category=373','category=374','category=375','category=376','category=377','category=378','category=379','category=380','category=381','category=382','category=383','category=384','category=385','category=386','category=387','category=388','category=389','category=390','category=391','category=392','category=393','category=394','category=395','category=396','category=397','category=398','category=399','category=540','category=541','category=542','category=543','category=544','category=545','category=546','category=547','category=548','category=549','category=550','category=551','category=552','category=553','category=554','category=555','category=556','category=557','category=558','category=559','category=560','category=561','category=562','category=563','category=564','category=565','category=566','category=567','category=568','category=569','category=570','category=571','category=572','category=573','category=574','category=575','category=576','category=577','category=578','category=579','category=580','category=581','category=582','category=583','category=584','category=585','category=586','category=587','category=588','category=589','category=590','category=591','category=592','category=593','category=594','category=595','category=596','category=597','category=598','category=599','category=780','category=781','category=782','category=783','category=784','category=785','category=786','category=787','category=788','category=789','category=790','category=791','category=792','category=793','category=794','category=795','category=796','category=797','category=798','category=799','category=820','category=821','category=822','category=823','category=824','category=825','category=826','category=827','category=828','category=829','category=832','category=833','category=834','category=835','category=836','category=837','category=838','category=839','category=205','category=206','category=207','category=208','category=209','category=260','category=261','category=262','category=263','category=264','category=265','category=266','category=267','category=268','category=269','category=270','category=271','category=272','category=273','category=274','category=275','category=276','category=277','category=278','category=279','category=280','category=281','category=282','category=283','category=284','category=285','category=286','category=287','category=288','category=289','category=290','category=291','category=292','category=293','category=294','category=295','category=296','category=297','category=298','category=299','category=400','category=401','category=402','category=403','category=404','category=405','category=406','category=407','category=408','category=409','category=410','category=411','category=412','category=413','category=414','category=415','category=416','category=417','category=418','category=419','category=420','category=421','category=422','category=423','category=424','category=425','category=426','category=427','category=428','category=429','category=430','category=431','category=432','category=433','category=434','category=435','category=436','category=437','category=438','category=439','category=447','category=448','category=449','category=50','category=51','category=52','category=53','category=54','category=55','category=56','category=57','category=58','category=59','category=60','category=600','category=601','category=602','category=603','category=604','category=605','category=606','category=607','category=608','category=609','category=61','category=610','category=611','category=612','category=613','category=614','category=615','category=616','category=617','category=618','category=619','category=62','category=620','category=621','category=622','category=623','category=624','category=625','category=626','category=627','category=628','category=629','category=63','category=630','category=631','category=632','category=633','category=634','category=635','category=636','category=637','category=638','category=639','category=64','category=640','category=641','category=642','category=643','category=644','category=645','category=646','category=647','category=648','category=649','category=65','category=650','category=651','category=652','category=653','category=654','category=655','category=656','category=657','category=658','category=659','category=66','category=660','category=661','category=662','category=663','category=664','category=665','category=666','category=667','category=668','category=669','category=67','category=670','category=671','category=672','category=673','category=674','category=675','category=676','category=677','category=678','category=679','category=68','category=69','category=70','category=71','category=72','category=73','category=74','category=75','category=76','category=77','category=78','category=79','category=80','category=800','category=801','category=802','category=803','category=804','category=805','category=806','category=807','category=808','category=809','category=81','category=810','category=811','category=812','category=813','category=814','category=815','category=816','category=817','category=818','category=819','category=82','category=83','category=830','category=831','category=84','category=840','category=841','category=842','category=843','category=844','category=845','category=846','category=847','category=848','category=849','category=85','category=850','category=851','category=852','category=853','category=854','category=855','category=856','category=857','category=858','category=859','category=86','category=860','category=861','category=862','category=863','category=864','category=865','category=866','category=867','category=868','category=869','category=87','category=870','category=871','category=872','category=873','category=874','category=875','category=876','category=877','category=878','category=879','category=88','category=880','category=881','category=882','category=883','category=884','category=885','category=886','category=887','category=888','category=889','category=89','category=890','category=891','category=892','category=893','category=894','category=895','category=896','category=897','category=898','category=899','category=90','category=91','category=92','category=93','category=94','category=95','category=96','category=97','category=98','category=99','category=200','category=201','category=202','category=203','category=204','category=210','category=211','category=212','category=213','category=214','category=215','category=216','category=217','category=218','category=219','category=220','category=221','category=222','category=223','category=224','category=225','category=226','category=227','category=228','category=229','category=230','category=231','category=232','category=233','category=234','category=235','category=236','category=237','category=238','category=239','category=240','category=241','category=242','category=243','category=244','category=245','category=246','category=247','category=248','category=249','category=250','category=251','category=252','category=253','category=254','category=255','category=256','category=257','category=258','category=259','category=440','category=441','category=442','category=443','category=444','category=445','category=446','category=450','category=451','category=452','category=453','category=454','category=455','category=456','category=457','category=458','category=459','category=460','category=461','category=462','category=463','category=464','category=465','category=466','category=467','category=468','category=469','category=470','category=471','category=472','category=473','category=474','category=475','category=476','category=477','category=478','category=479','category=480','category=481','category=482','category=483','category=484','category=485','category=486','category=487','category=488','category=489','category=490','category=491','category=492','category=493','category=494','category=495','category=496','category=497','category=498','category=499','category=500','category=501','category=502','category=503','category=504','category=505','category=506','category=507','category=508','category=509','category=510','category=511','category=512','category=513','category=514','category=515','category=516','category=517','category=518','category=519','category=520','category=521','category=522','category=523','category=524','category=525','category=526','category=527','category=528','category=529','category=535','category=536','category=537','category=538','category=539','category=680','category=681','category=682','category=683','category=684','category=685','category=686','category=687','category=688','category=689','category=690','category=691','category=692','category=693','category=694','category=695','category=696','category=697','category=698','category=699','category=700','category=701','category=702','category=703','category=704','category=705','category=706','category=707','category=708','category=709','category=710','category=711','category=712','category=713','category=714','category=715','category=716','category=717','category=718','category=719','category=720','category=721','category=722','category=723','category=724','category=725','category=726','category=727','category=728','category=729','category=730','category=731','category=732','category=733','category=734','category=735','category=736','category=737','category=738','category=739','category=740','category=741','category=742','category=743','category=744','category=745','category=746','category=747','category=748','category=749','category=750','category=751','category=752','category=753','category=754','category=755','category=756','category=757','category=758','category=759','category=760','category=761','category=762','category=763','category=764','category=765','category=766','category=767','category=768','category=769','category=777','category=778','category=779','category=940','category=941','category=942','category=943','category=944','category=945','category=946','category=947','category=948','category=949','category=950','category=951','category=952','category=953','category=954','category=955','category=956','category=957','category=958','category=959','category=960','category=961','category=962','category=963','category=964','category=965','category=966','category=967','category=968','category=969','category=970','category=971','category=972','category=973','category=974','category=975','category=976','category=977','category=978','category=979','category=980','category=981','category=982','category=983','category=984','category=985','category=986','category=987','category=988','category=989','category=990','category=991','category=992','category=993','category=994','category=995','category=996','category=997','category=998','category=999','category=1','category=10','category=11','category=12','category=13','category=14','category=15','category=16','category=17','category=18','category=19','category=2','category=20','category=21','category=22','category=23','category=24','category=25','category=26','category=27','category=28','category=29','category=3','category=30','category=31','category=32','category=33','category=34','category=35','category=36','category=37','category=38','category=39','category=4','category=40','category=41','category=42','category=43','category=44','category=45','category=46','category=47','category=48','category=49','category=5','category=530','category=531','category=532','category=533','category=534','category=6','category=7','category=770','category=771','category=772','category=773','category=774','category=775','category=776','category=8','category=9','category=900','category=901','category=902','category=903','category=904','category=905','category=906','category=907','category=908','category=909','category=910','category=911','category=912','category=913','category=914','category=915','category=916','category=917','category=918','category=919','category=920','category=921','category=922','category=923','category=924','category=925','category=926','category=927','category=928','category=929','category=930','category=931','category=932','category=933','category=934','category=935','category=936','category=937','category=938','category=939') AND C0.CTLG_NAME = ?
> NestedThrowables:
> java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
> at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:676)
> at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:456)
> at org.datanucleus.api.jdo.JDOQuery.executeWithArray(JDOQuery.java:318)
> at org.apache.hadoop.hive.metastore.ObjectStore.alterPartitions(ObjectStore.java:5257)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:97)
> at com.sun.proxy.$Proxy29.alterPartitions(Unknown Source)
> at org.apache.hadoop.hive.metastore.HiveAlterHandler.alterPartitions(HiveAlterHandler.java:876)
> at org.apache.hadoop.hive.metastore.HMSHandler.alter_partitions_with_environment_context(HMSHandler.java:5962)
> at org.apache.hadoop.hive.metastore.HMSHandler.alter_partitions_req(HMSHandler.java:5908)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:146)
> ... 38 more
> Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)