Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
VamsiBhagavathula1
Creator
Creator
‎2023-12-06 05:45 AM

Data Load failure as its not recognising column names which is included in `` special characters

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?

 

VamsiBhagavathula1_0-1701859299619.png

Best Regards

Vamsi

Labels (3)
Labels
2,473 Views
0 Likes
10 Replies
marcus_sommer
MVP
MVP
‎2023-12-07 10:25 AM

In response to VamsiBhagavathula1

Before looking for a bug make sure that nothing else may affect the load - means using a new application only with this load-statement and nothing else. What happens?

The next might be to load the data with the working * wildcard and storing the table as qvd. Afterwards using the table-wizard to create a load-statement from this qvd. Are the field-names really like you are typing them - or is there maybe any space, quote, line-break or whatever included and/or they are in upper/lower/capitalized letters which might be working in HIVE but Qlik is case-sensitive and/or the field-names may be completely different if HIVE accepts some kinds of aliases or similar stuff?

245 Views
0 Likes