Forum Discussion
ERROR [HY000] [Microsoft][ImpalaODBC] (110)
Hi,
I keep getting this error whenever i try to filter rows on power query. When i close and apply changes the error occurs. The column i'm filtering is a integer type. I'm using an ODBC Impala conector ODBC Version: 03.80 Driver Version: 2.7.2.1011. Powerbi version is Versão: 2.140.1078.0 64-bit . Any idea if this is something on the server side or something i should adjust on my device?
This error started around october of 2024 and i cant figure out what is the problem.
"Erro do OLE DB ou do ODBC : [DataSource.Error] ODBC: ERROR [HY000] [Microsoft][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : ParseException: Syntax error in line 25:
where (({ fn convert(`column_name...^Encountered: Unexpected character
Expected: CASE, CAST, DATE, DEFAULT, EXISTS, FALSE, GROUPING, IF, INTERVAL, LEFT, NOT, NULL, REPLACE, RIGHT, SELECT, TRUNCATE, TRUE, UNNEST, VALUES, WITH, IDENTIFIER CAUSED BY: Exception: Syntax error ."
Thank you for your attention and contributions.
Hi freitagar ,Could you check for these please
Review Power Query Steps: Ensure the column is correctly detected as an integer and that transformations are valid for Impala.
Inspect SQL Query: Use Power BI’s Performance Analyzer to capture the SQL query and check for syntax issues, especially around {fn Convert}.
- Also try CAST function and check for the latest ODBC driver or download latest Impala ODBC
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
8 Replies
- Akash_Varuna
Super User
Hi freitagar ,Could you check for these please
Review Power Query Steps: Ensure the column is correctly detected as an integer and that transformations are valid for Impala.
Inspect SQL Query: Use Power BI’s Performance Analyzer to capture the SQL query and check for syntax issues, especially around {fn Convert}.
- Also try CAST function and check for the latest ODBC driver or download latest Impala ODBC
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
v-ssriganeshCommunity Support
Hi freitagar,
Could you please confirm if your query have been resolved by the solution provided by Akash_Varuna? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.Thank you.
Hi Akash_Varuna thank you for your suggestions.
This error shows in a simple query with no previous table transformation. The column has native integer values. I've tried to include the CAST function but the Advanced Editor wont recognize it. Is there a place other than the Advanced Editor where i can edit the SQL function created ?
If it helps, this is the code on the Advanced Editor for the whole query:
let Source = Impala.Database("server.address", null), dior_share_Schema = Fonte{[Name="name_folder",Kind="Schema"]}[Data], table_View = name_folder_Schema{[Name="table",Kind="View"]}[Data], #"Filtered Lines" = Table.SelectRows(table_View, each [num_year] >= 2024) in #"Filtered Lines"- Akash_Varuna
Hi freitagar Could you try with native query that might solve the issue by native query yyou could use sql CAST also
- v-ssriganesh
Hi freitagar,
Thank you, Akash_Varuna, for sharing your valuable response.
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
- v-ssriganesh
Hi freitagar,
May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
