Hello,

I'm trying to export SequenceFiles created by my MapReduce job to a SQL
Server table for analysis. To do this, I first ran sqoop-codegen to create
a SqoopRecord class Sqoop can use.

However, sqoop-codegen used Strings for the SQL Server money fields. This
results in "Error converting data type nvarchar to decimal" errors when I
try to export.

The Microsoft SQL Server JDBC driver maps money columns to BigDecimal:
https://msdn.microsoft.com/en-us/library/ms378878(v=sql.110).aspx

I can't find any mention of money in the user guide, whereas there is
mention of specific Oracle types.
I'm also having immense difficulty finding any documentation at all on
exporting SequenceFiles.

Is money supported? I know I can use decimal instead, but just want to be
sure before modifying my table.

Reply via email to