Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, customerSQL SELECT *FROM HIVE.attunity.`call_req` where `call_req`.type = `P`