Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Why drill query is giving error while retrieving csv file. Tis same query working in Drill console.

SqlState: S1002, ErrorCode: 10670, ErrorMsg: [MapR][ODBC] (10670) Invalid descriptor index, descriptor record does not exist, or is not properly initialized.: PredictedCalls: SELECT columns[0] as column_0, columns[1] as column_1, columns[2] as column_2, columns[3] as column_3 FROM `dfs`.`default`.`momentum/user/workdir/bibhuti/yearmondayhourforpredresult/contents/czentrixfactorextract_1453741568478_1453742250.csv`

LIB CONNECT TO 'MapR ODBC Driver For Drill DSN83';

PredictedCalls:

SELECT columns[0] as column_0, columns[1] as column_1, columns[2] as column_2, columns[3] as column_3 FROM `dfs`.`default`.`momentum/user/workdir/bibhuti/yearmondayhourforpredresult/contents/czentrixfactorextract_1453741568478_1453742250.csv`;

DisConnect;

0 Replies