Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qlik Sense is unable to recognise the columns with special characters during the load script.
I am trying to load a table based on ODBC connection to HIVE DB and immediately encountering this issue. Does anybody faced the issue similar and resolved dealing with this special characters during load script?
Best Regards
Vamsi
I never tried with HIVE db. So it is just guessed
in Load statement remove column name and add *. Like
Load *;
SQL SELECT ..... your query....
Regards,
Prashant Sangle
@PrashantSangle : Thanks for taking a look into this and responding.
Load * works but i dont want that.
I expect that the load script generated by the Qlik sense connector by default should work. However this is not the case. Hence struggling to get some support. In my task, i should also rename few columns and exclude some columns in load script. So i need to have this load script fixed.
looking forward if any more suggestions that i could try with
Best Regards
vamsi
@VamsiBhagavathula1 Could you please load removing Special Characters ` `
Load row_number;
@sidhiq91 : it failed
Hi, I would suggest to try 2 things:
- Try to insert the data directly from the sql server connection and you will understand where the error is
OR
- Try to create OLE DB connection
@panosalexand sorry . i am using Hive not sql server.
Ok, then try to load the whole table as raw data just to understand how to read the columns. Potentially the format from hive is different when you insert on sense.
@panosalexand : it failed even with whole table as well. Columns in Load statement are not at all recognized by qlik. The only work around which helped me is renaming columns in SQL and use the alias columns into load statement. However this is a work around. I had to deal with many tables while constructing the app and i dont want to rename columns in sql for every table. So checking if qlik can fix this bug somehow??
Can you try loading with *. ?? Don't use any field as a restriction.
Please try the following:
Load *;
SQL SELECT * from
your connection ;