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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

hadoop loading into qlkview

I am loading data from  hadoop database , while loading from database and storing into qvd i am getting the below eror

SQL##f - SqlState: S1000, ErrorCode: 80, ErrorMsg: [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 2:49 Invalid table alias or column reference 'P': (possible column names are: id,  no, summary, description, status,  open_date, time_spent_sum, last_mod_dt, last_mod_by, close_date, resolve_date,  assignee, group_id, customer
SQL SELECT *
FROM HIVE.attunity.`call_req` where `call_req`.type = `P` 
 

0 Replies