I am trying to export the output of the following query . Before that I want to set some hive properties.
I am building the query using various context variables.
"select tbl.hd from (select tab1.hd, tab1.cl1 from (" + context.getProperty("CUSTOM_SEL") + context.getProperty("HDR_COL) + context.getProperty("CUST_HEADER") + context.getProperty("CUST_UNION") + context.SQL_TEXT+") tab1 order by tab1.cl1 asc ) tbl"
Is there way I can execute the SET hive parameters before executing select query ?
In the tHiveConnection component, click the 'Advanced settings', click the '+' under 'Hive Properties' and for each property:
Yes. That works. But we have parameterized the query and we want to parameterize those "HIVE Set params" through a context variable. That way we can set different set of parameters for different hive queries. This way we have to hard code it for all the queries.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks