Release Notes for Sqoop 1.4.0-incubating: November, 2011

Release Notes - Sqoop - Version 1.4.0-incubating

Sub-task

• [SQOOP-370] - Version number for upcoming release.
• [SQOOP-371] - Migrate util package to new name space
• [SQOOP-374] - Migrate tool and orm packages to new name space
• [SQOOP-375] - Migrate metastore and metastore.hsqldb packages to new name space
• [SQOOP-376] - Migrate mapreduce package to new name space
• [SQOOP-377] - Migrate mapreduce.db package to new name space
• [SQOOP-378] - Migrate manager package to new name space
• [SQOOP-379] - Migrate lib and io packages to new name space
• [SQOOP-380] - Migrate hive and hbase packages to new name space
• [SQOOP-381] - Migrate cli and config packages to new name space
• [SQOOP-383] - Version tool is not working.
• [SQOOP-386] - Namespace migration cleanup
• [SQOOP-388] - Add license header to Hive testdata
• [SQOOP-389] - Include change log

Bug

• [SQOOP-308] - Generated Avro Schema cannot handle nullable fields
• [SQOOP-314] - Basic export hangs when target database does not support INSERT syntax with multiple rows of values
• [SQOOP-317] - OracleManager should allow working with tables owned by other users.
• [SQOOP-319] - The --hive-drop-import-delims option should accept a replacement string
• [SQOOP-323] - Support for the NVARCHAR datatype
• [SQOOP-325] - Sqoop doesn't build on intellij
• [SQOOP-329] - SQOOP doesn't work with the DB2 JCC driver
• [SQOOP-330] - Free form query import with column transformation failed without obvious error message
• [SQOOP-332] - Cannot use --as-avrodatafile with --query
• [SQOOP-336] - Avro import does not support varbinary types
• [SQOOP-338] - NPE after specifying incorrect JDBC credentials
• [SQOOP-339] - Use of non-portable mknod utility causes build problems on Mac OS X
• [SQOOP-340] - Rise exception when both --direct and --as--sequencefile or --as-avrodatafile are given
• [SQOOP-341] - Sqoop doesn't handle unsigned ints at least with MySQL
• [SQOOP-346] - Sqoop needs to be using java version 1.6 for its source
• [SQOOP-349] - A bunch of the fields are wrong in pom.xml
• [SQOOP-358] - Sqoop import fails on netezza nvarchar datatype with --as-avrodatafile
• [SQOOP-359] - Import fails with Unknown SQL datatype exception
• [SQOOP-364] - Default getCurTimestampQuery() in SqlManager is not working for PostgreSQL
• [SQOOP-368] - Resolve ERROR tool.ImportTool: Imported Failed: Duplicate Column identifier specified: 'COLUMN-NAME'
• [SQOOP-373] - Can only write to default file system on direct import
• [SQOOP-385] - Typo in PostgresqlTest.java regarding configuring postgresql.conf.

Improvement

• [SQOOP-303] - Use Catalog Tables for PostgresqlManager
• [SQOOP-315] - Update Avro version to 1.5.2
• [SQOOP-316] - Sqoop user guide should have a troubleshooting section.
• [SQOOP-318] - Add support for splittable lzo files with Hive
• [SQOOP-320] - Use Information Schema for SQLServerManager
• [SQOOP-321] - Support date/time columns for "--incremental append" option
• [SQOOP-326] - Updgrade Avro dependency to version 1.5.3
• [SQOOP-351] - Sqoop User Guide's troubleshooting section should include Case-Sensitive Catalog Query Errors
• [SQOOP-353] - Cleanup the if/else statement in HiveTypes
• [SQOOP-354] - SQOOP needs to be made compatible with Hadoop .23 release
• [SQOOP-355] - improve SQOOP documentation of Avro data file support
• [SQOOP-357] - To make debugging easier, Sqoop should print out all the exceptions
• [SQOOP-361] - [Docs] $CONDITIONS must be escaped to not allow shells to replace it.
• [SQOOP-366] - Sqoop User Guide's troubleshooting section should include MySQL setup instructions

New Feature

• [SQOOP-305] - Support export from Avro Data Files
• [SQOOP-313] - Multiple column names to be included in --update-key argument with SQOOP export (update)
• [SQOOP-327] - Mixed update/insert export support for OracleManager
• [SQOOP-331] - Support boundary query on the command line
• [SQOOP-342] - Allow user to override sqoop type mapping
• [SQOOP-367] - codegen support free-form query

Task

• [SQOOP-302] - Use Information Schema for MySQLManager
• [SQOOP-309] - Update Sqoop dependency versions
• [SQOOP-310] - Review license headers