Return
-
Title
Get "Object reference not set to an instance of an object" running 'Select count(*)...' on Hive ODBC connection -
Description
When trying to use a "select count(*) from table" statement on a Hive ODBC connection, an "Object reference not set to an instance of an object" error message is returned. This error will also occur during a data compare, which uses a Hive ODBC connection, with this statement for the same reason. -
Cause
Error is coming from ODBC driver due to 'Select count(*)' statement. -
Resolution
Contact the vendor about why 'Select count(*)' causes an error with their ODBC driver.