Export to mysql and add a column

[Scott Gallavan]

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