Hadoop和数据库数据迁移工具 Apache Sqoop 1.4.2 发布
openkk 12年前
<p><img alt="Hadoop和数据库数据迁移工具 Apache Sqoop 1.4.2 发布" src="https://simg.open-open.com/show/689159be5cca28c98f7437803040d7c6.gif" width="331" height="80" /></p> <p>Sqoop是一个用来将Hadoop和关系型数据库中的数据相互转移的工具,可以将一个关系型数据库(例如 : MySQL ,Oracle ,Postgres等)中的数据导入到Hadoop的HDFS中,也可以将HDFS的数据导入到关系型数据库中。</p> <h2>Sub-task</h2> <ul> <li>[<a href="/misc/goto?guid=4958522799719276685">SQOOP-470</a>] - Create tests for blob support for Avro import</li> </ul> <h2>Bug</h2> <ul> <li>[<a href="/misc/goto?guid=4958522799845375958">SQOOP-352</a>] - Export of avro data imported from database table (using sqoop import) fails on year</li> <li>[<a href="/misc/goto?guid=4958522799957624802">SQOOP-410</a>] - Direct modes can't import views</li> <li>[<a href="/misc/goto?guid=4958522800073351292">SQOOP-425</a>] - Sqoop invokes ResultSet.isLast() which causes Sybase JDBC driver to hang</li> <li>[<a href="/misc/goto?guid=4958522800202170220">SQOOP-445</a>] - Wrong query for getListColumnsQuery in PostgresqlManager</li> <li>[<a href="/misc/goto?guid=4958522800317942393">SQOOP-448</a>] - boolean fields get nullified during postgres direct import into hive.</li> <li>[<a href="/misc/goto?guid=4958522800446588970">SQOOP-450</a>] - Direct MySQL import can fail when using mysqldump version 5.1.14 or above.</li> <li>[<a href="/misc/goto?guid=4958522800580219468">SQOOP-452</a>] - Mysql free form queries fail if alias is not used.</li> <li>[<a href="/misc/goto?guid=4958522800701394178">SQOOP-453</a>] - Oozie does not work with Sqoop metastore</li> <li>[<a href="/misc/goto?guid=4958522800824418631">SQOOP-454</a>] - Upgrade dependency on HBase version 0.92.0-SNAPSHOT as it was already released</li> <li>[<a href="/misc/goto?guid=4958522800939099466">SQOOP-460</a>] - Verbose logging does not turn the level for correct logger</li> <li>[<a href="/misc/goto?guid=4958522801055906207">SQOOP-468</a>] - Oracle free form queries fail.</li> <li>[<a href="/misc/goto?guid=4958522801181426160">SQOOP-473</a>] - Sqoop import-all-tables fails with MySQL connector</li> <li>[<a href="/misc/goto?guid=4958522801310716185">SQOOP-474</a>] - Split-by specification incorrectly triggers bounding value query</li> <li>[<a href="/misc/goto?guid=4958522801439636036">SQOOP-476</a>] - If table name is a qualified name, Sqoop import fails in DB2</li> <li>[<a href="/misc/goto?guid=4958522801554195124">SQOOP-480</a>] - MS SQL server connector and OraOop connector are incompatible with Sqoop-1.4</li> <li>[<a href="/misc/goto?guid=4958522801679445383">SQOOP-481</a>] - Sqoop import with --hive-import using wrong column names in --columns throws a NPE</li> <li>[<a href="/misc/goto?guid=4958522801793434029">SQOOP-482</a>] - import tool for mysql direct mode reports wrong record number</li> <li>[<a href="/misc/goto?guid=4958522801922806232">SQOOP-488</a>] - Parameter for extended verbose is not working due to migrated code to different module</li> <li>[<a href="/misc/goto?guid=4958522802040280455">SQOOP-489</a>] - Cannot define partition keys for Hive tables created through Sqoop</li> <li>[<a href="/misc/goto?guid=4958522802175148329">SQOOP-490</a>] - Style error in the trunk</li> <li>[<a href="/misc/goto?guid=4958522802288729797">SQOOP-503</a>] - --columns argument support for export</li> <li>[<a href="/misc/goto?guid=4958522802426239911">SQOOP-505</a>] - Trailing space after jar in managers.d/connectors causes file not found</li> <li>[<a href="/misc/goto?guid=4958522802557179045">SQOOP-508</a>] - Sqoop metastore cannot be started due to missing hsqldb jar file</li> <li>[<a href="/misc/goto?guid=4958522802683119636">SQOOP-521</a>] - Import fails on tables with names containing hyphens ( - )</li> <li>[<a href="/misc/goto?guid=4958522802816956304">SQOOP-524</a>] - hsqldb jar update regression</li> <li>[<a href="/misc/goto?guid=4958522802953347888">SQOOP-528</a>] - Remove references to incubator from sources</li> <li>[<a href="/misc/goto?guid=4958522803089588178">SQOOP-536</a>] - Blob import doesn't work with avro 1.7.1</li> <li>[<a href="/misc/goto?guid=4958522803211469839">SQOOP-539</a>] - getPrimaryKeyQuery is very slow in mysql 5.0.77</li> <li>[<a href="/misc/goto?guid=4958522803337494386">SQOOP-571</a>] - Revert SQOOP-519 and SQOOP-524</li> </ul> <p>新版本改进记录请看:<a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12320141&styleName=&projectId=12311320" target="_blank">ReleaseNotes</a></p>