[
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)
