<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: SQOOP IMPORT --map-column-hive ignored in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/SQOOP-IMPORT-map-column-hive-ignored/m-p/47131#M45640</link>
    <description>&lt;P&gt;&lt;a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/13282"&gt;@kerjo&lt;/a&gt;, I'm seeing the same issue.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;CDH 5.8.2 (w/ sqoop 1.4.6)&lt;/LI&gt;&lt;LI&gt;MariaDB 5.5, or AWS Redshift, or..&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Given the following sqoop invocation:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;sqoop                                         \
import                                        \
--map-column-hive LoggedTime=timestamp        \
--connect jdbc:mysql://madb-t:3306/Sardata    \
--username reader                             \
--password 'xx'                               \
--hive-table 'memory'                         \
--table 'Memory'                              \
--as-parquetfile                              \
--target-dir '/user/sardata/mem'              \
--hive-overwrite                              \
--hive-import&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I find that the &lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;--map-column-hive&lt;/FONT&gt;&lt;/STRONG&gt; option is totally ignored. (It doesn't matter if I set it to LoggedTime=string, LoggedTime=blah, or PurpleMonkeyDishwasher=sdfjsaldkjf. It is ignored.)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I noticed tonight that if I avoid Parquet and instead use&amp;nbsp;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;--as-textfile&lt;/FONT&gt;&lt;/STRONG&gt;&amp;nbsp;the&amp;nbsp;&lt;STRONG&gt;&lt;FONT face="courier new,courier"&gt;--map-column-hive&lt;/FONT&gt;&lt;/STRONG&gt;&amp;nbsp;option works correctly. I do not know the reason for this behavior at the moment. And I still need to get the files into Parquet format for Impala to report against. Just wanted to share my observation.&lt;/P&gt;</description>
    <pubDate>Tue, 08 Nov 2016 04:41:03 GMT</pubDate>
    <dc:creator>eriks</dc:creator>
    <dc:date>2016-11-08T04:41:03Z</dc:date>
  </channel>
</rss>

