topic Re: Define query in talend context using tSystem component in Talend Studio

Define query in talend context using tSystem component

WSyahirah21 — Fri, 15 Nov 2024 23:11:38 GMT

I am trying to run an impala command using the tSystem component in Talend Studio. I am able to run the command in terminal .

impala-shell -i hostname:21000 -d default -k --ssl -q "COMPUTE STATS DEFAULT.TABLENAME;"

I tried to apply the same command in tSystem component. so, the command in TOS will be appied by this way:

In Talend context:

hostname = hostname:21000

database = default

tablename = default.tablename

Impala command I defined in tSystem component:

"impala-shell -i context.hostname -d context.database -k --ssl -q "COMPUTE STATS context.tablename;""

However, I got an error for this line -> `-q "COMPUTE STATS context.tablename;"`

Is there any ways I could use the string query in my impala command using tSystem component in TOS? Appreciate any helps. Thanks.

Re: Define query in talend context using tSystem component

Anonymous — Mon, 21 Feb 2022 07:28:07 GMT

You don't use the context variable in a string correctly, try this expression:

"impala-shell -i context.hostname -d context.database -k --ssl -q 'COMPUTE STATS "+context.tablename+"';"

Re: Define query in talend context using tSystem component

WSyahirah21 — Mon, 21 Feb 2022 08:08:48 GMT

Hi Shong, I received following error:

Query: 'COMPUTE STATS tablename;'

Query submitted at: 2022-02-21 16:05:17 (Coordinator: https://hostname:25000)

ERROR: ParseException: Syntax error in line 1:

'COMPUTE STATS tablename;'

Encountered: STRING LITERAL

Expected: ALTER, COMMENT, COMPUTE, COPY, CREATE, DELETE, DESCRIBE, DROP, EXPLAIN, GRANT, INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, UPDATE, UPSERT, USE, VALUES, WITH

CAUSED BY: Exception: Syntax error

Could not execute command: 'COMPUTE STATS tablename;'