mercredi 3 décembre 2014

Query on a MS SQL View with openquery to Hive returning wrong answer


I have a view on an MS SQL Database Engine instance which is running an OPENQUERY to Hive through MS OLE DB Provider. The view is getting all the records from the Hive table without any where clause. Now, I suspect that a query on the SQL view to find max value on a column is sometimes returning wrong value. In any case, is it possible that the MAX query ran on the view even in case it wasn't able to fetch all the records from the Hive table, due to which the query returned wrong value?





Aucun commentaire:

Enregistrer un commentaire