topic Why drill query is giving error while retrieving csv file. Tis same query working in Drill console. in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Why-drill-query-is-giving-error-while-retrieving-csv-file-Tis/m-p/1079438#M1716 <HTML><HEAD></HEAD><BODY><P class="selectable" style="margin: 0 0 0 5px;">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`</P><DIV class="selectable created" style="margin: 5px 0 0 5px; color: #545352;"><P class="selectable" style="margin: 0 0 0 5px;"></P><P>LIB CONNECT TO 'MapR ODBC Driver For Drill DSN83';</P><P>PredictedCalls:</P><P>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`;</P><P>DisConnect;</P></DIV></BODY></HTML> Wed, 27 Jan 2016 09:30:50 GMT 2016-01-27T09:30:50Z Why drill query is giving error while retrieving csv file. Tis same query working in Drill console. https://community.qlik.com/t5/Connectivity-Data-Prep/Why-drill-query-is-giving-error-while-retrieving-csv-file-Tis/m-p/1079438#M1716 <HTML><HEAD></HEAD><BODY><P class="selectable" style="margin: 0 0 0 5px;">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`</P><DIV class="selectable created" style="margin: 5px 0 0 5px; color: #545352;"><P class="selectable" style="margin: 0 0 0 5px;"></P><P>LIB CONNECT TO 'MapR ODBC Driver For Drill DSN83';</P><P>PredictedCalls:</P><P>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`;</P><P>DisConnect;</P></DIV></BODY></HTML> Wed, 27 Jan 2016 09:30:50 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Why-drill-query-is-giving-error-while-retrieving-csv-file-Tis/m-p/1079438#M1716 2016-01-27T09:30:50Z