Member since
11-12-2024
1
Post
0
Kudos Received
0
Solutions
11-12-2024
08:26 PM
using command ALTER TABLE test table DROP PARTITION (START_DATE = DATE_ADD('2023-09-13', -13) ) error: SQL Error [500051] [HY000]: [Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement. Error Code: 40000, SQL state: TStatus(statusCode:ERROR_STATUS, info Messages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:78 cannot recognize input near 'DATE_ADD' '(' ''2023-09-13'' in constant:17:16 Need Result : '2023-08-31'
... View more
Labels: