Context: I am connecting to hive, via the official ODBC driver of HDP. This driver tries to be smart, and fails quite miserably. To short-circuit the “smartness” I can ask it to pass the query as-is to hive, but if the query has parameters, (eg. placeholder in a manual SQL input in a Cube), then this fails as Hive cannot process question marks in a query.
After a lot of tinkering and swearing, I came to the conclusion that the best way for me would be to generate the SQL (maybe via a dundas script, or a python step, or maybe just by reading it from disk (where a python step could have generated it :))) and feed it to the sql step.
Is it at all possible to do something like that? My feeling is that’s it’s not possible, but I would love to be shown that I am lying.