hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shared mailinglists <shared.mailingli...@gmail.com>
Subject Hive & MS SQL Server
Date Thu, 24 Mar 2011 15:01:39 GMT
Hi Hive users :-)



Does anybody have experience of using Hive with MS SQL Server 2005? I’m
currently stumped with the following issue
https://issues.apache.org/jira/browse/HIVE-1391 where Hive (or DataNucleus?)
confuses the COLUMNS table it requires internally with that of the default
SQL Server sys.COLUMNS or information_schema.COLUMNS View and therefore does
not automatically create the required metadata table when running the Hive
CLI.


Has anybody managed to get Hive to work with SQLServer 2005 or know how I
can configure Hive to use a different table name to COLUMNS ? Unfortunately
we have to use SQL Server and do not have the option to use Derby or MySQL
etc.



Many thanks,


Andy.

Mime
View raw message