topic Re: What kind of Qlik Script 'Support' for Teradata-specific query is there? in Connectivity & Data Prep

What kind of Qlik Script 'Support' for Teradata-specific query is there?

cheenu_janakira — Wed, 10 Oct 2018 12:46:39 GMT

Hello everyone,

This is an RFI for the Teradata-experienced community with regard to whether Qlik (notably QlikSense) 'supports' script syntax for Teradata-specific queries.

Does anyone have Teradata experience, especially in regard to whether Qlik can handle an SQL statement prefix of "validtime as of date 'YYYY-MM-DD' "?

I don't want to write a typical WHERE clause, as none of the fields in the table are indexed and the data (table size) will grow with time (it's a historical table). I'm trying to prevent a full table scan and was notified by Teradata experts that this was achievable with a query prefix of "validtime as of date 'YYYY-MM-DD' SEL [...]". I use a Qlik var to get the correct "YYYY-MM-DD" but when I prefix the SQL-Select statement/query with this in the Qlik script, I get an error ("The following error occurred: Unknown statement:").

The exact same statement that Qlik "errors" on, works when copy/pasted into Teradata Studio.

Does anyone have information on the types of Teradata queries supported by Qlik.

Valid Teradata-specific workaround(s) to propose?

Many thanks for your thoughts and help.

Kind regards,

Cheenu

Re: What kind of Qlik Script 'Support' for Teradata-specific query is there?

tomasz_tru — Wed, 10 Oct 2018 14:20:22 GMT

Temporal table? Is it possible to create view that you can just SELECT (...)?

Tomasz

Re: What kind of Qlik Script 'Support' for Teradata-specific query is there?

cheenu_janakira — Wed, 10 Oct 2018 15:19:54 GMT

Hi Tomasz,

Thank you. You lit the right spark.

I'm going to mark your answer as correct so that you get the points. When I was typing out an answer to your reply, I realised my mistake/omission. And "yes", a 'view' is a workaround, although this would have required a JIRA ticket, etc. as I don't have rights/permissions to create anything, only to read DB tables.

My answer to you was going to be "I am still curious why this doesn't work, as I have passed to the DB server many different things from a Qlik script".

Basically, my Qlik script was "load A, B, C; validtime as of date '$(vBUSINESS_PD)' Select A, B, C from "schema"."table";

I had copy/pasted the queries that were shared with me. I forgot to add "SQL" to identify what Qlik needed to pass on to the DB server. I realised this when I thought "[...] as I have passed to the DB server many different things from a Qlik script".

Therefore, the following script works:

"load A, B, C; SQL validtime as of date '$(vBUSINESS_PD)' Select A, B, C from "schema"."table";

Cheerio. Thank you for your help and time.

KR,

Cheenu