Hello @gtmanoj23051988 ,   thank you for the detailed issue description. It seems to be similar that was described in this thread, hence just summarising here the solution for your convenience:   Impala/Hive Driver tries to transform queries that were already in the Impala/Hive native form when UseNativeQuery is set to zero or not set at all causing the syntax error.   You can overcome this exception by adding UseNativeQuery=1 in the JDBC query string parameter.   Kind regards: Ferenc         ... View more

Here is a link of 5.5 hours of free Apache NiFi course.    https://www.udemy.com/course/apache-nifi-latest-course/?couponCode=LATESTNIFI ... View more