Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I’m facing issues while filtering using any of the "text columns" in direct query with Impala connector. Date & Number columns are working fine but all the string columns have issues in query.
Filters applied using - Slicers, Page/Report filters,etc.,
Error Message:
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Microsoft][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 1:
....`emp_name` AS STRING(30))='test') ) `OTBL` INNER ...
^
Encountered: (
Expected: BLOCK_SIZE, COMMENT, COMPRESSION, DEFAULT, ENCODING, INTERMEDIATE, LOCATION, NOT, NULL, PRIMARY, COMMA
CAUSED BY: Exception: Syntax error
Error Code:
QueryUserError
OData Error Message:
Failed to execute the DAX query.
I’ve tested the same data with import method, which works fine. Issue is only with direct query method.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.