[resolved] use Global Variable in tSqoopImport query ?

[Anonymous]

Hello - I am trying to use a Global Variable set in a previous step in tSqoopImport. I must have something wrong with my syntax.
Here is my query. Source system is Oracle.
"select  sysdate,  '\"+globalMap.get(\"Max_id\")+\"' from dual  where $CONDITIONS"
Here is the output it writes to file:

2016-03-21 15:25:04.0,"+globalMap.get("Max_id")+"

[Anonymous · Accepted solution]

I got it to work. Just needed to remove all the \
"select  sysdate,  '"+globalMap.get("Max_id")+"' from dual  where $CONDITIONS"