question Re: updating table in Support Questions

updating table

Tome — Fri, 16 Sep 2022 14:03:29 GMT

hello all,

Trying to update a table where date_num is a date(timestamp) and "day" is the field i want to update but i am getting errors

Anyhting wrong with the query below?

update anp_catdidai1_working.dim_bsp_date

set day=day(date_num)

Re: updating table

EricL — Wed, 16 Jan 2019 06:56:09 GMT

What's the error you are getting?

Have you tried to add ` around the day, since it is reserved as a UDF function? Like below:

update anp_catdidai1_working.dim_bsp_date set `day`=day(date_num);

Re: updating table

Tome — Sun, 20 Jan 2019 17:07:42 GMT

Hi EricL,

This is the error i get:

SQL Error [500051] [HY000]: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Syntax error in line 1:
update anp_catdidai1_working.dim_bsp_date
^
Encountered: IDENTIFIER
Expected: ALTER, COMPUTE, CREATE, DESCRIBE, DROP, EXPLAIN, GRANT, INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, USE, VALUES, WITH

CAUSED BY: Exception: Syntax error
), Query: update anp_catdidai1_working.dim_bsp_date
set day=day(date_num).
[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Syntax error in line 1:
update anp_catdidai1_working.dim_bsp_date
^
Encountered: IDENTIFIER
Expected: ALTER, COMPUTE, CREATE, DESCRIBE, DROP, EXPLAIN, GRANT, INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, USE, VALUES, WITH

CAUSED BY: Exception: Syntax error
), Query: update anp_catdidai1_working.dim_bsp_date
set day=day(date_num).
com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Syntax error in line 1:
update anp_catdidai1_working.dim_bsp_date
^
Encountered: IDENTIFIER
Expected: ALTER, COMPUTE, CREATE, DESCRIBE, DROP, EXPLAIN, GRANT, INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, USE, VALUES, WITH

CAUSED BY: Exception: Syntax error
), Query: update anp_catdidai1_working.dim_bsp_date
set day=day(date_num).

I also tried with 'day' and same error

Re: updating table

EricL — Mon, 21 Jan 2019 00:00:57 GMT

UPDATE statement in Impala?

Are you using KUDU as the underlining table? If not, then UPDATE is not supported. Please refer to below link:

https://www.cloudera.com/documentation/enterprise/latest/topics/impala_update.html

"This statement only works for Impala tables that use the Kudu storage engine."

Re: updating table

Tome — Wed, 23 Jan 2019 21:44:36 GMT

ah i see.

That makes sense now. Thank you