Release Notes for Sqoop 1.4.2: August, 2012

Release Notes - Sqoop - Version 1.4.2

Sub-task

[SQOOP-470] - Create tests for blob support for Avro import

Bug

[SQOOP-352] - Export of avro data imported from database table (using sqoop import) fails on year
[SQOOP-410] - Direct modes can't import views
[SQOOP-425] - Sqoop invokes ResultSet.isLast() which causes Sybase JDBC driver to hang
[SQOOP-445] - Wrong query for getListColumnsQuery in PostgresqlManager
[SQOOP-448] - boolean fields get nullified during postgres direct import into hive.
[SQOOP-450] - Direct MySQL import can fail when using mysqldump version 5.1.14 or above.
[SQOOP-452] - Mysql free form queries fail if alias is not used.
[SQOOP-453] - Oozie does not work with Sqoop metastore
[SQOOP-454] - Upgrade dependency on HBase version 0.92.0-SNAPSHOT as it was already released
[SQOOP-460] - Verbose logging does not turn the level for correct logger
[SQOOP-468] - Oracle free form queries fail.
[SQOOP-473] - Sqoop import-all-tables fails with MySQL connector
[SQOOP-474] - Split-by specification incorrectly triggers bounding value query
[SQOOP-476] - If table name is a qualified name, Sqoop import fails in DB2
[SQOOP-480] - MS SQL server connector and OraOop connector are incompatible with Sqoop-1.4
[SQOOP-481] - Sqoop import with --hive-import using wrong column names in --columns throws a NPE
[SQOOP-482] - import tool for mysql direct mode reports wrong record number
[SQOOP-488] - Parameter for extended verbose is not working due to migrated code to different module
[SQOOP-489] - Cannot define partition keys for Hive tables created through Sqoop
[SQOOP-490] - Style error in the trunk
[SQOOP-503] - --columns argument support for export
[SQOOP-505] - Trailing space after jar in managers.d/connectors causes file not found
[SQOOP-508] - Sqoop metastore cannot be started due to missing hsqldb jar file
[SQOOP-521] - Import fails on tables with names containing hyphens ( - )
[SQOOP-524] - hsqldb jar update regression
[SQOOP-528] - Remove references to incubator from sources
[SQOOP-536] - Blob import doesn't work with avro 1.7.1
[SQOOP-539] - getPrimaryKeyQuery is very slow in mysql 5.0.77
[SQOOP-571] - Revert SQOOP-519 and SQOOP-524

Improvement

[SQOOP-391] - Dependencies should use released versions of Apache Hadoop, HBase, and ZooKeeper
[SQOOP-416] - Allow code-generation arguments with Avro imports
[SQOOP-436] - The --verbose option should enable verbose logging for MapReduce jobs as well
[SQOOP-438] - allow sourcing of sqoop-env.sh to set various environment variables
[SQOOP-440] - Rename CHANGES.txt to CHANGELOG.txt
[SQOOP-442] - Ant target mvn-install is generating pom with dependencies on cloudera version of Hadoop
[SQOOP-443] - Calling sqoop with hive import is not working multiple times due to kept output directory
[SQOOP-447] - Use release version of Apache Hadoop 0.23.1 in build
[SQOOP-459] - Remove redundant steps in compatibility tests: verifyReadback() method
[SQOOP-461] - Sqoop User Guide's troubleshooting section should include Oracle Connection Errors
[SQOOP-463] - Sqoop User Guide's troubleshooting section should explain how to override the column mapping when importing a table from MySQL into Hive
[SQOOP-464] - Warn when user is importing data into /user/hive/warehouse with flag --hive-import
[SQOOP-465] - BLOB support for Avro import
[SQOOP-483] - Allow target dir to be set to a different name than table name for hive import
[SQOOP-484] - Update troubleshooting guide section about MySQL and TINYINT(1) columns
[SQOOP-487] - InformationSchemaManager.getPrimaryKeyQuery can take a very long time for large mysql table with partitions
[SQOOP-510] - Improve the error message for bad connector files
[SQOOP-522] - Move printing error "ERROR orm.CompilationManager: Could not rename" to DEBUG
[SQOOP-529] - Enforce usage of --driver and --connection-manager parameters
[SQOOP-538] - Hudson configuration for all hadoop versions

New Feature

[SQOOP-439] - Released artifacts should embrace unwritten naming policy
[SQOOP-444] - Support incremental import for free form queries

Task

[SQOOP-516] - Sqoop 1.4.2 release preparation
[SQOOP-519] - Update the version of hsqldb decadency to 2.X
[SQOOP-574] - Create a Hadoop-2.0.0 build profile