[jira] [Commented] (KYLIN-872) sqoop help

["samaya ranjan mohanty (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14614026#comment-14614026 ] 

samaya ranjan mohanty commented on KYLIN-872:
---------------------------------------------

how can you append varchar column data in hdfs using sqoop incremental append command . actually  i have one table which iis associated with another table but the problem is all are varchar column .every data is inserted but i want to pull the data from table to hdfs, when i run the sqoop i have facing the below issues.
[root@master ~]# sqoop import --connect jdbc:mysql://master/test --username root --password samaya --table Gtcj --incremental append --check-column testId -m 1
Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
15/07/04 11:29:15 INFO sqoop.Sqoop: Running Sqoop version: 1.4.3-cdh4.7.0
15/07/04 11:29:16 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
15/07/04 11:29:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
15/07/04 11:29:16 INFO tool.CodeGenTool: Beginning code generation
15/07/04 11:29:17 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `Gtcj` AS t LIMIT 1
15/07/04 11:29:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `Gtcj` AS t LIMIT 1
15/07/04 11:29:18 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/lib/hadoop-0.20-mapreduce
Note: /tmp/sqoop-root/compile/7ffedfb0b4a6fb471d27e54b5c394308/Gtcj.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
15/07/04 11:29:22 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/7ffedfb0b4a6fb471d27e54b5c394308/Gtcj.jar
15/07/04 11:29:22 INFO tool.ImportTool: Maximal id query for free form incremental import: SELECT MAX(`testId`) FROM Gtcj
15/07/04 11:29:22 ERROR tool.ImportTool: Error during import: Character column (testId) can not be used to determine which rows to incrementally import.
==

could you please help me regarding the same?

> sqoop help
> ----------
>
>                 Key: KYLIN-872
>                 URL: https://issues.apache.org/jira/browse/KYLIN-872
>             Project: Kylin
>          Issue Type: Bug
>          Components: Web 
>            Reporter: samaya ranjan mohanty
>            Assignee: Zhong,Jason
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)