title: Hortonworks Hive ODBC Driver DB-240000
body: <blockquote>
    <p>DB-240000 ODBC error: [Hortonworks][Hardy] (80) Syntax or semantic
    analysis error thrown in server while executing query. </p>
    
    <p>Error message from server: Error while compiling statement: FAILED:
    ParseException line 1:12 cannot recognize input near 'ALL_ROWS'</p>
    
    <p>'*' '/' in hint name SQLState: 37000</p>
  </blockquote>
  
  <p>Sample query</p>
  
  <pre><code>WDB-200001 SQL statement 'SELECT  /*+ ALL_ROWS */ A.test FROM table A' could not be executed.
  </code></pre>
  
  <p>Syntax looks right as per documentation (<a href="https://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements006.htm#SQLRF51108" rel="nofollow noreferrer">https://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements006.htm#SQLRF51108</a>)</p>
  
  <p>Or is there a missing param on the odbc configuration?
  <a href="https://hortonworks.com/wp-content/uploads/2015/10/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf" rel="nofollow noreferrer">https://hortonworks.com/wp-content/uploads/2015/10/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf</a></p>
  
  <blockquote>
    <p>Use Native Query Key Name Default Value Required UseNativeQuery Clear
    (0) No Architecting the Future of Big Data Hortonworks Inc. Page 71
    Description When this option is enabled (1), the driver does not
    transform the queries emitted by an application, so the native query
    is used. When this option is disabled (0), the driver transforms the
    queries emitted by an application and converts them into an equivalent
    from in HiveQL. Note: If the application is Hive-aware and already
    emits Hive</p>
  </blockquote>
  
  <ol>
  <li>Could this be an issue with HDP versioning? </li>
  <li>Is there a missing Param
  in the ODBC connection string?</li>
  </ol>