Sorry to become a bit offtopic but how do you get into a situation where
sqlserver 2005 becomes a requirement for a hive internal meta store?
I doubt many of the developers of hive will have access to this database
so I don't expect a lot of response on this. But hopefully someone can
prove me wrong :)
Bennie.
On 03/24/2011 04:01 PM, shared mailinglists wrote:
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.
