*when i try to sqoop import into my hive the following error :

sqoop import --connect jdbc:mysql://localhost:3306/hue  --table inters
--direct-split-size 8  --hive-import --create-hive-table --username hues -P

*

ERROR tool.ImportTool: Encountered IOException running import job:
java.io.IOException: Hive exited with status 9
       at
com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
       at
com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
       at
com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
       at
com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:395)
       at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456)
       at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
       at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
       at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
       at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
       at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
       at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) this is the error
in import when i use --import-hive

*and also when i try to import the same table twice it says directory
already contains the name specified so how to tackle this
situation??????????*

Hi Soham,

Can you try doing a sqoop import while specifying your table as
database.table (i.e. with dot notation)?

Regards, Kathleen

On Wed, Jun 6, 2012 at 11:47 PM, soham sardar <[EMAIL PROTECTED]>wrote:

> *when i try to sqoop import into my hive the following error :
>
> sqoop import --connect jdbc:mysql://localhost:3306/hue  --table inters
> --direct-split-size 8  --hive-import --create-hive-table --username hues -P
>
> *
>
> ERROR tool.ImportTool: Encountered IOException running import job:
> java.io.IOException: Hive exited with status 9
>        at
> com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
>        at
> com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
>        at
> com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
>        at
> com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:395)
>        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456)
>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) this is the error
> in import when i use --import-hive
>
>
>
> *and also when i try to import the same table twice it says directory
> already contains the name specified so how to tackle this
> situation??????????*

no there isint any change if i specify my command as
*sqoop import --connect jdbc:mysql://localhost:3306/hue --table hue.users
--username hues -P --hive-import   --hive-table Audit_logs
*
can u gimme some other alternative ......
On Thu, Jun 7, 2012 at 12:45 PM, Kathleen Ting <[EMAIL PROTECTED]> wrote:

> Hi Soham,
>
> Can you try doing a sqoop import while specifying your table as
> database.table (i.e. with dot notation)?
>
> Regards, Kathleen
>
>
> On Wed, Jun 6, 2012 at 11:47 PM, soham sardar <[EMAIL PROTECTED]>wrote:
>
>> *when i try to sqoop import into my hive the following error :
>>
>> sqoop import --connect jdbc:mysql://localhost:3306/hue  --table inters
>> --direct-split-size 8  --hive-import --create-hive-table --username hues -P
>>
>> *
>>
>> ERROR tool.ImportTool: Encountered IOException running import job:
>> java.io.IOException: Hive exited with status 9
>>        at
>> com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
>>        at
>> com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
>>        at
>> com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
>>        at
>> com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:395)
>>        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456)
>>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
>>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
>>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
>>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
>>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) this is the
>> error in import when i use --import-hive
>>
>>
>>
>> *and also when i try to import the same table twice it says directory
>> already contains the name specified so how to tackle this
>> situation??????????*
>
>
>

Hi Soham,
what sqoop version are you using? Also could you please send us entire execution stack executed with --verbose option?

The issue with repeated HIVE import and exception "FileAlreadyExistsException" is known and was fixed in SQOOP-443 that will be included in next version. Workaround for older versions is to manually remove empty staging directory left in the default location. For example by calling:

hadoop dfs -rmr $tableName # Remove directory $tableName from your home directory

Jarcec

On Thu, Jun 07, 2012 at 01:21:31PM +0530, soham sardar wrote:
> no there isint any change if i specify my command as
>
>
> *sqoop import --connect jdbc:mysql://localhost:3306/hue --table hue.users
> --username hues -P --hive-import   --hive-table Audit_logs
> *
> can u gimme some other alternative ......
> On Thu, Jun 7, 2012 at 12:45 PM, Kathleen Ting <[EMAIL PROTECTED]> wrote:
>
> > Hi Soham,
> >
> > Can you try doing a sqoop import while specifying your table as
> > database.table (i.e. with dot notation)?
> >
> > Regards, Kathleen
> >
> >
> > On Wed, Jun 6, 2012 at 11:47 PM, soham sardar <[EMAIL PROTECTED]>wrote:
> >
> >> *when i try to sqoop import into my hive the following error :
> >>
> >> sqoop import --connect jdbc:mysql://localhost:3306/hue  --table inters
> >> --direct-split-size 8  --hive-import --create-hive-table --username hues -P
> >>
> >> *
> >>
> >> ERROR tool.ImportTool: Encountered IOException running import job:
> >> java.io.IOException: Hive exited with status 9
> >>        at
> >> com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
> >>        at
> >> com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
> >>        at
> >> com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
> >>        at
> >> com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:395)
> >>        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456)
> >>        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
> >>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> >>        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
> >>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
> >>        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
> >>        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) this is the
> >> error in import when i use --import-hive
> >>
> >>
> >>
> >> *and also when i try to import the same table twice it says directory
> >> already contains the name specified so how to tackle this
> >> situation??????????*
> >
> >
> >

version ======= Sqoop 1.3.0-cdh3u4
the command used is :

*hduser@XPS-L501X:~$ sqoop import --connect jdbc:mysql://localhost:3306/hue
--table users --username hues -P --hive-import   --hive-table Audit_logs
--verbose
*
12/06/07 14:08:35 DEBUG tool.BaseSqoopTool: Enabled debug logging.
Enter password:
12/06/07 14:08:42 INFO tool.BaseSqoopTool: Using Hive-specific delimiters
for output. You can override
12/06/07 14:08:42 INFO tool.BaseSqoopTool: delimiters with
--fields-terminated-by, etc.
12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
com.cloudera.sqoop.manager.DefaultManagerFactory
12/06/07 14:08:42 DEBUG manager.DefaultManagerFactory: Trying with scheme:
jdbc:mysql:
12/06/07 14:08:42 INFO manager.MySQLManager: Preparing to use a MySQL
streaming resultset.
12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Instantiated ConnManager
com.cloudera.sqoop.manager.MySQLManager@1c0ec97
12/06/07 14:08:42 INFO tool.CodeGenTool: Beginning code generation
12/06/07 14:08:42 DEBUG manager.SqlManager: No connection paramenters
specified. Using regular API for making connection.
12/06/07 14:08:42 DEBUG manager.SqlManager: Using fetchSize for next query:
-2147483648
12/06/07 14:08:42 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `users` AS t LIMIT 1
12/06/07 14:08:42 DEBUG orm.ClassWriter: selected columns:
12/06/07 14:08:42 DEBUG orm.ClassWriter:   id
12/06/07 14:08:42 DEBUG orm.ClassWriter:   userid
12/06/07 14:08:42 DEBUG orm.ClassWriter:   logtime
12/06/07 14:08:42 DEBUG manager.SqlManager: Using fetchSize for next query:
-2147483648
12/06/07 14:08:42 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `users` AS t LIMIT 1
12/06/07 14:08:42 DEBUG orm.ClassWriter: Writing source file:
/tmp/sqoop-hduser/compile/e684ff81eaff45d92efa7dd1b659c79c/users.java
12/06/07 14:08:42 DEBUG orm.ClassWriter: Table name: users
12/06/07 14:08:42 DEBUG orm.ClassWriter: Columns: id:4, userid:4,
logtime:93,
12/06/07 14:08:42 DEBUG orm.ClassWriter: sourceFilename is users.java
12/06/07 14:08:42 DEBUG orm.CompilationManager: Found existing
/tmp/sqoop-hduser/compile/e684ff81eaff45d92efa7dd1b659c79c/
12/06/07 14:08:42 INFO orm.CompilationManager: HADOOP_HOME is
/usr/lib/hadoop
12/06/07 14:08:42 INFO orm.CompilationManager: Found hadoop core jar at:
/usr/lib/hadoop/hadoop-0.20.2-cdh3u4-core.jar
12/06/07 14:08:42 DEBUG orm.CompilationManager: Adding source file:
/tmp/sqoop-hduser/compile/e684ff81eaff45d92efa7dd1b659c79c/users.java
12/06/07 14:08:42 DEBUG orm.CompilationManager: Invoking javac with args:
12/06/07 14:08:42 DEBUG orm.CompilationManager:   -sourcepath
12/06/07 14:08:42 DEBUG orm.CompilationManager:
/tmp/sqoop-hduser/compile/e684ff81eaff45d92efa7dd1b659c79c/
12/06/07 14:08:42 DEBUG orm.CompilationManager:   -d
12/06/07 14:08:42 DEBUG orm.CompilationManager:
/tmp/sqoop-hduser/compile/e684ff81eaff45d92efa7dd1b659c79c/
12/06/07 14:08:42 DEBUG orm.CompilationManager:   -classpath
12/06/07 14:08:42 DEBUG orm.CompilationManager:
/usr/lib/hadoop/conf:/usr/lib/jvm/java-6-openjdk/lib/tools.jar:/usr/lib/hadoop:/usr/lib/hadoop/hadoop-core-0.20.2-cdh3u4.jar:/usr/lib/hadoop/lib/ant-contrib-1.0b3.jar:/usr/lib/hadoop/lib/aspectjrt-1.6.5.jar:/usr/lib/hadoop/lib/aspectjtools-1.6.5.jar:/usr/lib/hadoop/lib/commons-cli-1.2.jar:/usr/lib/hadoop/lib/commons-codec-1.4.jar:/usr/lib/hadoop/lib/commons-daemon-1.0.1.jar:/usr/lib/hadoop/lib/commons-el-1.0.jar:/usr/lib/hadoop/lib/commons-httpclient-3.1.jar:/usr/lib/hadoop/lib/commons-lang-2.4.jar:/usr/lib/hadoop/lib/commons-logging-1.0.4.jar:/usr/lib/hadoop/lib/commons-logging-api-1.0.4.jar:/usr/lib/hadoop/lib/commons-net-3.1.jar:/usr/lib/hadoop/lib/core-3.1.1.jar:/usr/lib/hadoop/lib/guava-r09-jarjar.jar:/usr/lib/hadoop/lib/hadoop-fairscheduler-0.20.2-cdh3u4.jar:/usr/lib/hadoop/lib/hsqldb-1.8.0.10.jar:/usr/lib/hadoop/lib/hue-plugins-1.2.0-cdh3u4.jar:/usr/lib/hadoop/lib/jackson-core-asl-1.5.2.jar:/usr/lib/hadoop/lib/jackson-mapper-asl-1.5.2.jar:/usr/lib/hadoop/lib/jasper-compiler-5.5.12.jar:/usr/lib/hadoop/lib/jasper-runtime-5.5.12.jar:/usr/lib/hadoop/lib/jets3t-0.6.1.jar:/usr/lib/hadoop/lib/jetty-6.1.26.cloudera.1.jar:/usr/lib/hadoop/lib/jetty-servlet-tester-6.1.26.cloudera.1.jar:/usr/lib/hadoop/lib/jetty-util-6.1.26.cloudera.1.jar:/usr/lib/hadoop/lib/jsch-0.1.42.jar:/usr/lib/hadoop/lib/junit-4.5.jar:/usr/lib/hadoop/lib/kfs-0.2.2.jar:/usr/lib/hadoop/lib/log4j-1.2.15.jar:/usr/lib/hadoop/lib/mockito-all-1.8.2.jar:/usr/lib/hadoop/lib/oro-2.0.8.jar:/usr/lib/hadoop/lib/servlet-api-2.5-20081211.jar:/usr/lib/hadoop/lib/servlet-api-2.5-6.1.14.jar:/usr/lib/hadoop/lib/slf4j-api-1.4.3.jar:/usr/lib/hadoop/lib/slf4j-log4j12-1.4.3.jar:/usr/lib/hadoop/lib/xmlenc-0.52.jar:/usr/lib/hadoop/lib/jsp-2.1/jsp-2.1.jar:/usr/lib/hadoop/lib/jsp-2.1/jsp-api-2.1.jar:/usr/lib/sqoop/conf:/etc/zookeeper::/usr/lib/sqoop/lib/ant-contrib-1.0b3.jar:/usr/lib/sqoop/lib/ant-eclipse-1.0-jvm1.2.jar:/usr/lib/sqoop/lib/avro-1.5.4.jar:/usr/lib/sqoop/lib/avro-ipc-1.5.4.jar:/usr/lib/sqoop/lib/avro-mapred-1.5.4.jar:/usr/lib/sqoop/lib/commons-io-1.4.jar:/usr/lib/sqoop/lib/hadoop-mrunit-0.20.2-CDH3b2-SNAPSHOT.jar:/usr/lib/sqoop/lib/jackson-core-asl-1.7.3.jar:/usr/lib/sqoop/lib/jackson-mapper-asl-1.7.3.jar:/usr/lib/sqoop/lib/jopt-simple-3.2.jar:/usr/lib/sqoop/lib/mysql-connector-java-5.1.20-bin.jar:/usr/lib/sqoop/lib/paranamer-2.3.jar:/usr/lib/sqoop/lib/snappy-java-1.0.3.2.jar:/usr/lib/hbase/bin/../conf:/usr/lib/jvm/java-6-openjdk/lib/tools.jar:/usr/lib/hbase/bin/..:/usr/lib/hbase/bin/../hbase-0.90.6-cdh3u4.jar:/usr/lib/hbase/bin/../hbase-0.90.6-cdh3u4-tests.jar:/usr/lib/hbase/bin/../lib/activation-1.1.jar:/usr/lib/hbase/bin/../lib/asm-3.1.jar:/usr/lib/hbase/bin/../lib/avro-1.5.4.jar:/usr/lib/hbase/bin/../lib/avro-ipc-1.5.4.jar:/usr/lib/hbase/bin/../lib/commons-cli-1.2.jar:/usr/lib/hbase/bin/../lib/commons-codec-1.4.jar:/usr/lib/hbase/bin/../lib/commons-el-1.0.jar:/usr/lib/hbase

*whenever i do a hive-import from my mysql database
with the command
 sqoop import --connect jdbc:mysql://localhost:3306/hue --table users
--username hues -P
Enter password:
it works fine and when i also check my hadoop file system it is present

*hduser@XPS-L501X:~$ hadoop dfs -ls
Found 10 items
drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:15
/user/hduser/_sqoop
drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:16
/user/hduser/infor
drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:20
/user/hduser/inform
drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:56
/user/hduser/information
drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:29
/user/hduser/inter
drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:19
/user/hduser/intern
drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:26
/user/hduser/interns
drwxr-xr-x   - hduser supergroup          0 2012-06-06 17:22
/user/hduser/inters
drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:38
/user/hduser/logs-export
*drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:48
/user/hduser/users
*
but when i try to run queries via the hive shell, am unable to view the
contents
Hive history
file=/tmp/hduser/hive_job_log_hduser_201206071553_1184972028.txt
*hive> select * from users ;*
FAILED: Error in semantic analysis: Unable to fetch table users
hive>

can someone help me with this error
On Thu, Jun 7, 2012 at 2:10 PM, soham sardar <[EMAIL PROTECTED]>wrote:

> version ======= Sqoop 1.3.0-cdh3u4
>
>
> the command used is :
>
> *hduser@XPS-L501X:~$ sqoop import --connect
> jdbc:mysql://localhost:3306/hue --table users --username hues -P
> --hive-import   --hive-table Audit_logs --verbose
> *
>
>
>
>
> 12/06/07 14:08:35 DEBUG tool.BaseSqoopTool: Enabled debug logging.
> Enter password:
> 12/06/07 14:08:42 INFO tool.BaseSqoopTool: Using Hive-specific delimiters
> for output. You can override
> 12/06/07 14:08:42 INFO tool.BaseSqoopTool: delimiters with
> --fields-terminated-by, etc.
> 12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Loaded manager factory:
> com.cloudera.sqoop.manager.DefaultManagerFactory
> 12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
> com.cloudera.sqoop.manager.DefaultManagerFactory
> 12/06/07 14:08:42 DEBUG manager.DefaultManagerFactory: Trying with scheme:
> jdbc:mysql:
> 12/06/07 14:08:42 INFO manager.MySQLManager: Preparing to use a MySQL
> streaming resultset.
> 12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Instantiated ConnManager
> com.cloudera.sqoop.manager.MySQLManager@1c0ec97
> 12/06/07 14:08:42 INFO tool.CodeGenTool: Beginning code generation
> 12/06/07 14:08:42 DEBUG manager.SqlManager: No connection paramenters
> specified. Using regular API for making connection.
> 12/06/07 14:08:42 DEBUG manager.SqlManager: Using fetchSize for next
> query: -2147483648
> 12/06/07 14:08:42 INFO manager.SqlManager: Executing SQL statement: SELECT
> t.* FROM `users` AS t LIMIT 1
> 12/06/07 14:08:42 DEBUG orm.ClassWriter: selected columns:
> 12/06/07 14:08:42 DEBUG orm.ClassWriter:   id
> 12/06/07 14:08:42 DEBUG orm.ClassWriter:   userid
> 12/06/07 14:08:42 DEBUG orm.ClassWriter:   logtime
> 12/06/07 14:08:42 DEBUG manager.SqlManager: Using fetchSize for next
> query: -2147483648
> 12/06/07 14:08:42 INFO manager.SqlManager: Executing SQL statement: SELECT
> t.* FROM `users` AS t LIMIT 1
> 12/06/07 14:08:42 DEBUG orm.ClassWriter: Writing source file:
> /tmp/sqoop-hduser/compile/e684ff81eaff45d92efa7dd1b659c79c/users.java
> 12/06/07 14:08:42 DEBUG orm.ClassWriter: Table name: users
> 12/06/07 14:08:42 DEBUG orm.ClassWriter: Columns: id:4, userid:4,
> logtime:93,
> 12/06/07 14:08:42 DEBUG orm.ClassWriter: sourceFilename is users.java
> 12/06/07 14:08:42 DEBUG orm.CompilationManager: Found existing
> /tmp/sqoop-hduser/compile/e684ff81eaff45d92efa7dd1b659c79c/
> 12/06/07 14:08:42 INFO orm.CompilationManager: HADOOP_HOME is
> /usr/lib/hadoop
> 12/06/07 14:08:42 INFO orm.CompilationManager: Found hadoop core jar at:

*now i have error in the hive export command where in i type the comand
hduser@XPS-L501X:~$ sqoop export --connect jdbc:mysql://localhost:3306/hue
--table users_e  --username hues --password iamthedon --export-dir
/user/hduser/users

*and the result shows

INFO mapred.JobClient:     HDFS_BYTES_READ=327922
12/06/07 16:15:55 INFO mapred.JobClient:     FILE_BYTES_WRITTEN=179382
12/06/07 16:15:55 INFO mapred.JobClient:   Map-Reduce Framework
12/06/07 16:15:55 INFO mapred.JobClient:     Map input records=10000
12/06/07 16:15:55 INFO mapred.JobClient:     Physical memory (bytes)
snapshot=335163392
12/06/07 16:15:55 INFO mapred.JobClient:     Spilled Records=0
12/06/07 16:15:55 INFO mapred.JobClient:     CPU time spent (ms)=5810
12/06/07 16:15:55 INFO mapred.JobClient:     Total committed heap usage
(bytes)=131530752
12/06/07 16:15:55 INFO mapred.JobClient:     Virtual memory (bytes)
snapshot=1510580224
12/06/07 16:15:55 INFO mapred.JobClient:     Map output records=10000
12/06/07 16:15:55 INFO mapred.JobClient:     SPLIT_RAW_BYTES=417
12/06/07 16:15:55 INFO mapreduce.ExportJobBase: Transferred 320.2363 KB in
9.2161 seconds (34.7476 KB/sec)
*12/06/07 16:15:55 INFO mapreduce.ExportJobBase: Exported 10000 records.*

now what my understanding is from the export command is that i am trying to
export the info from the hadoop fs dir /user/hduser/users and trying to
dump into the table users_e under database hue (which is already been
created with the same column parameters ) ...

and another problem is i need to know how to get the info as a text file
and not inside the mysql table ??? .....

any help would be great on this :)
On Thu, Jun 7, 2012 at 3:55 PM, soham sardar <[EMAIL PROTECTED]>wrote:

> *whenever i do a hive-import from my mysql database
> with the command
>
>
>  sqoop import --connect jdbc:mysql://localhost:3306/hue --table users
> --username hues -P
> Enter password:
> it works fine and when i also check my hadoop file system it is present
>
> *hduser@XPS-L501X:~$ hadoop dfs -ls
> Found 10 items
> drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:15
> /user/hduser/_sqoop
> drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:16
> /user/hduser/infor
> drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:20
> /user/hduser/inform
> drwxr-xr-x   - hduser supergroup          0 2012-06-06 15:56
> /user/hduser/information
> drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:29
> /user/hduser/inter
> drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:19
> /user/hduser/intern
> drwxr-xr-x   - hduser supergroup          0 2012-06-06 16:26
> /user/hduser/interns
> drwxr-xr-x   - hduser supergroup          0 2012-06-06 17:22
> /user/hduser/inters
> drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:38
> /user/hduser/logs-export
> *drwxr-xr-x   - hduser supergroup          0 2012-06-07 15:48
> /user/hduser/users
> *
> but when i try to run queries via the hive shell, am unable to view the
> contents
> Hive history
> file=/tmp/hduser/hive_job_log_hduser_201206071553_1184972028.txt
> *hive> select * from users ;*
> FAILED: Error in semantic analysis: Unable to fetch table users
> hive>
>
> can someone help me with this error
>
>
>
> On Thu, Jun 7, 2012 at 2:10 PM, soham sardar <[EMAIL PROTECTED]>wrote:
>
>> version ======= Sqoop 1.3.0-cdh3u4
>>
>>
>> the command used is :
>>
>> *hduser@XPS-L501X:~$ sqoop import --connect
>> jdbc:mysql://localhost:3306/hue --table users --username hues -P
>> --hive-import   --hive-table Audit_logs --verbose
>> *
>>
>>
>>
>>
>> 12/06/07 14:08:35 DEBUG tool.BaseSqoopTool: Enabled debug logging.
>> Enter password:
>> 12/06/07 14:08:42 INFO tool.BaseSqoopTool: Using Hive-specific delimiters
>> for output. You can override
>> 12/06/07 14:08:42 INFO tool.BaseSqoopTool: delimiters with
>> --fields-terminated-by, etc.
>> 12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Loaded manager factory:
>> com.cloudera.sqoop.manager.DefaultManagerFactory
>> 12/06/07 14:08:42 DEBUG sqoop.ConnFactory: Trying ManagerFactory: