sqoop Servname not supported for ai_socktype
时间:2010-08-03 来源:zhangzhu1984
[root@vm16 ~]# sqoop import --connect jdbc:postgresql://vm8/test --table a_1 --direct
10/08/03 09:33:02 INFO tool.CodeGenTool: Beginning code generation
10/08/03 09:33:02 INFO manager.PostgresqlManager: Executing SQL statement: SELECT t.* FROM a_1 AS t LIMIT 1
10/08/03 09:33:02 INFO manager.PostgresqlManager: Executing SQL statement: SELECT t.* FROM a_1 AS t LIMIT 1
10/08/03 09:33:02 INFO orm.CompilationManager: HADOOP_HOME is /home/hadoop/hadoop
Note: /root/./a_1.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
10/08/03 09:33:03 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop/compile/a_1.jar
10/08/03 09:33:03 INFO manager.DirectPostgresqlManager: Beginning psql fast path import
10/08/03 09:33:03 INFO manager.PostgresqlManager: Executing SQL statement: SELECT t.* FROM a_1 AS t LIMIT 1
10/08/03 09:33:03 INFO manager.DirectPostgresqlManager: Performing import of table a_1 from database test
10/08/03 09:33:04 INFO manager.DirectPostgresqlManager: psql: could not translate host name "vm8" to address: Servname not supported for ai_socktype
10/08/03 09:33:04 INFO manager.DirectPostgresqlManager: Transfer loop complete.
10/08/03 09:33:04 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: psql terminated with status 2
[root@vm16 ~]# ping vm8
PING vm8 (10.25.115.8) 56(84) bytes of data.
64 bytes from vm8 (10.25.115.8): icmp_seq=1 ttl=64 time=0.501 ms
--- vm8 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.501/0.501/0.501/0.000 ms
[root@vm16 ~]# sqoop import --connect jdbc:postgresql://vm8:5432/test --table a_1 --direct
10/08/03 09:40:00 INFO tool.CodeGenTool: Beginning code generation
10/08/03 09:40:01 INFO manager.PostgresqlManager: Executing SQL statement: SELECT t.* FROM a_1 AS t LIMIT 1
10/08/03 09:40:01 INFO manager.PostgresqlManager: Executing SQL statement: SELECT t.* FROM a_1 AS t LIMIT 1
10/08/03 09:40:01 INFO orm.CompilationManager: HADOOP_HOME is /home/hadoop/hadoop
Note: /root/./a_1.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
10/08/03 09:40:02 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop/compile/a_1.jar
10/08/03 09:40:02 INFO manager.DirectPostgresqlManager: Beginning psql fast path import
10/08/03 09:40:02 INFO manager.PostgresqlManager: Executing SQL statement: SELECT t.* FROM a_1 AS t LIMIT 1
10/08/03 09:40:02 INFO manager.DirectPostgresqlManager: Performing import of table a_1 from database test
10/08/03 09:40:03 INFO manager.DirectPostgresqlManager: Transfer loop complete.
10/08/03 09:40:03 INFO manager.DirectPostgresqlManager: Transferred 682 bytes in 0.2984 seconds (2.2317 KB/sec)
[root@vm16 ~]#