Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

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

Tomasz

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

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

Tomasz

View solution in original post

Highlighted
Creator
Creator

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