Cloudera Community
Jmeks
user rank
Explorer

Re: Delete partition Hive error

by Explorer in Support Questions
‎02-24-2022 02:17 AM
‎02-24-2022 02:17 AM
Many Thanks. I finally managed to delete the partitions using your code ... View more

Re: Delete partition Hive error

by Explorer in Support Questions
‎02-22-2022 03:17 AM
‎02-22-2022 03:17 AM
Hi mszurap,   i use HDP-3.1.0.0. the data type for the `date` partitioning column is date ... View more

Re: Delete partition Hive error

by Explorer in Support Questions
‎02-21-2022 04:17 AM
‎02-21-2022 04:17 AM
Hi Miklos,   I appreciate your help but using your code still throws the following error:   | date=2019-11-13 | | date=2022-02-15 | | date=2022-02-16 | | date=2022-02-17 | | date=2022-02-19 | | date=2022-02-20 | | date=__HIVE_DEFAULT_PARTITION__ | +----------------------------------+ 790 rows selected (0.284 seconds) 0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP IF EXISTS PARTITION (`date`="2019-11-13"); Error: Error while compiling statement: FAILED: SemanticException Unexpected unknown partitions for (date = DATE'2019-11-13') (state=42000,code=40000) ... View more

Delete partition Hive error

by Explorer in Support Questions
‎02-20-2022 11:48 PM
‎02-20-2022 11:48 PM
Hi guys, i am trying some hive partitions but i am getting the following errors. kindly help figure out the problem.   0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP IF EXISTS PARTITION (date='date=2019-11-13') PURGE; Error: Error while compiling statement: FAILED: ParseException line 1:67 cannot recognize input near 'date' '=' ''date=2019-11-13'' in drop partition statement (state=42000,code=40000) 0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP IF EXISTS PARTITION (date='date="2019-11-13"') PURGE; Error: Error while compiling statement: FAILED: ParseException line 1:67 cannot recognize input near 'date' '=' ''date="2019-11-13"'' in drop partition statement (state=42000,code=40000) 0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP IF EXISTS PARTITION (date=`2019-11-13`) PURGE; Error: Error while compiling statement: FAILED: ParseException line 1:67 cannot recognize input near 'date' '=' '2019-11-13' in drop partition statement (state=42000,code=40000) 0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP IF EXISTS PARTITION (date >='1648-10-03', date <='2022-02-15') ; Error: Error while compiling statement: FAILED: ParseException line 1:67 cannot recognize input near 'date' '>=' ''1648-10-03'' in drop partition statement (state=42000,code=40000) 0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP IF EXISTS PARTITION (date >='1648-10-03'); Error: Error while compiling statement: FAILED: ParseException line 1:67 cannot recognize input near 'date' '>=' ''1648-10-03'' in drop partition statement (state=42000,code=40000) 0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP PARTITION (date >='1644948900', date <='1644949001'); Error: Error while compiling statement: FAILED: ParseException line 1:57 cannot recognize input near 'date' '>=' ''1644948900'' in drop partition statement (state=42000,code=40000) 0: jdbc:hive2://svdt5hadoopms02.bigdatadev.sa> ALTER TABLE customer_transaction_extract DROP PARTITION (date >='1644948900', date <='1644949001'); Error: Error while compiling statement: FAILED: ParseException line 1:57 cannot recognize input near 'date' '>=' ''164494 ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎10-24-2024 03:25 AM
Community Statistics
Member Since ‎02-20-2022 11:42 PM
Last Visited ‎10-24-2024 03:25 AM
Posts 4