Hi, I would like to use the database query editor node to add a column ‘test’ to a datatable I have connected to, via Hive, in the database. I use the following SQL statement that results an error.
ALTER TABLE #table#
ADD test VARCHAR(25)
Similarly, the simple SQL code ‘SELECT * FROM #table#’ results in an error also, which I seemingly resolved by adding 'SELECT * FROM #table# as temp '…
I have tried adding as temp to the the first statement to no avail.
The error is ‘Execute failed: [Cloudera]HiveJDBCDriver ERROR processing query/statement. Error Code: 40000, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:15 cannot recognize input near ‘(’ ‘ALTER’ ‘TABLE’…’
Any help or guidance is appreciated