sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Gallavan <sgalla...@gmail.com>
Subject Export to mysql and add a column
Date Fri, 04 Dec 2015 19:03:15 GMT
I wanted to export a dataset from hive -> mysql

But I need to add a string column that is required in mysql but not present
in hive.
I know the string and it is constant for the entire export.

Is there an elegant way to do this in hive without adding a new column? or
a new table to hive?

What would be the best way to do that?Can I write a custom select statement
for the hive insert?

I was hoping that this

--columns col1,col2,col3,$customValue

would work, but that is not working for me.



Thanks


Scott

Mime
View raw message