Users may see the following error while querying Hive2 database in TDV:

No Push Reason: Cannot push selectable because the data source Hive2 does not support the function --ROW_NUMBER()

Follow the steps provided here to resolve the error:

 1. Open  file apache_hive_2_x_values present under the path,
      TDV Installation Directory\conf\adapters\system\apache_hive_2_x. 

2. Append the below lines to the file.

<?xml version="1.1" encoding="UTF-8"?>
<common:attributes xmlns:common="http://www.compositesw.com/services/system/util/common">
<common:attribute xmlns:common="http://www.compositesw.com/services/system/util/common">
  <common:name>/custom/ROW_NUMBER().analytic</common:name>
  <common:type>STRING</common:type>
  <common:value>ROW_NUMBER()</common:value>
  <common:configID>ROW_NUMBER().analytic</common:configID>
</common:attribute></common:attributes>

3. Save the file and restart the TDV server.

4. Execute the query.