Hi All,

         We can update the records in the Hive table,if so please tell me
the syntax in hive.

Regards,
shaik.

Hi Shaik

Updates are not supported in hive. Still you can accomplish updates by over writing either a whole table or a partition.

In short updates are not directly supported in hive, indirectly it is really expensive as well.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: shaik ahamed <[EMAIL PROTECTED]>
Date: Wed, 4 Jul 2012 16:24:05
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Hi

Hi All,

         We can update the records in the Hive table,if so please tell me
the syntax in hive.

Regards,
shaik.

Hi all,

         As im trying to insert the data in to the hive table as im
getting the below error

Total MapReduce jobs = 2
Launching Job 1 out of 2
Number of reduce tasks is set to 0 since there's no reduce operator
org.apache.hadoop.ipc.RemoteException: java.io.IOException:
org.apache.hadoop.fs.FSError: java.io.IOException: No space left on device
        at
org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.write(RawLocalFileSystem.java:192)
        at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
        at java.io.FilterOutputStream.close(FilterOutputStream.java:140)
        at
org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:61)
        at
org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:86)
        at
org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.close(ChecksumFileSystem.java:347)
        at
org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:61)
        at
org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:86)
        at org.apache.hadoop.io.IOUtils.copyBytes(IOUtils.java:57)
        at org.apache.hadoop.io.IOUtils.copyBytes(IOUtils.java:85)
        at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:209)
        at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:142)
        at
org.apache.hadoop.fs.FileSystem.copyToLocalFile(FileSystem.java:1216)
        at
org.apache.hadoop.fs.FileSystem.copyToLocalFile(FileSystem.java:1197)
        at
org.apache.hadoop.mapred.JobInProgress.<init>(JobInProgress.java:257)
        at
org.apache.hadoop.mapred.JobInProgress.<init>(JobInProgress.java:234)
        at
org.apache.hadoop.mapred.JobTracker.submitJob(JobTracker.java:2993)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:508)
        at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:959)
        at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:955)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at org.apache.hadoop.ipc.Server$Handler.run(Server.java:953)
        at org.apache.hadoop.ipc.Client.call(Client.java:740)
        at org.apache.hadoop.ipc.RPC$Invoker.invoke(RPC.java:220)
        at org.apache.hadoop.mapred.$Proxy6.submitJob(Unknown Source)
        at
org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:800)
        at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:730)
        at
org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:435)
        at
org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:137)
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
        at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
        at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
        at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
        at
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
        at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
Job Submission failed with exception
'org.apache.hadoop.ipc.RemoteException(java.io.IOException:
org.apache.hadoop.fs.FSError: java.io.IOException: No space left on device
        at
org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.write(RawLocalFileSystem.java:192)
        at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
        at java.io.FilterOutputStream.close(FilterOutputStream.java:140)
        at
org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:61)
        at
org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:86)
        at
org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.close(ChecksumFileSystem.java:347)
        at
org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:61)
        at
org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:86)
        at org.apache.hadoop.io.IOUtils.copyBytes(IOUtils.java:57)
        at org.apache.hadoop.io.IOUtils.copyBytes(IOUtils.java:85)
        at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:209)
        at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:142)
        at
org.apache.hadoop.fs.FileSystem.copyToLocalFile(FileSystem.java:1216)
        at
org.apache.hadoop.fs.FileSystem.copyToLocalFile(FileSystem.java:1197)
        at
org.apache.hadoop.mapred.JobInProgress.<init>(JobInProgress.java:257)
        at
org.apache.hadoop.mapred.JobInProgress.<init>(JobInProgress.java:234)
        at
org.apache.hadoop.mapred.JobTracker.submitJob(JobTracker.java:2993)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAcce

"No space left on device" this mean your HDD is full.

On Fri, Jul 6, 2012 at 10:25 PM, shaik ahamed <[EMAIL PROTECTED]> wrote:

> Hi all,
>
>          As im trying to insert the data in to the hive table as im
> getting the below error
>
> Total MapReduce jobs = 2
> Launching Job 1 out of 2
> Number of reduce tasks is set to 0 since there's no reduce operator
> org.apache.hadoop.ipc.RemoteException: java.io.IOException:
> org.apache.hadoop.fs.FSError: java.io.IOException: No space left on device
>         at
> org.apache.hadoop.fs.RawLocalFileSystem$LocalFSFileOutputStream.write(RawLocalFileSystem.java:192)
>         at
> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
>         at
> java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
>         at java.io.FilterOutputStream.close(FilterOutputStream.java:140)
>         at
> org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:61)
>         at
> org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:86)
>         at
> org.apache.hadoop.fs.ChecksumFileSystem$ChecksumFSOutputSummer.close(ChecksumFileSystem.java:347)
>         at
> org.apache.hadoop.fs.FSDataOutputStream$PositionCache.close(FSDataOutputStream.java:61)
>         at
> org.apache.hadoop.fs.FSDataOutputStream.close(FSDataOutputStream.java:86)
>         at org.apache.hadoop.io.IOUtils.copyBytes(IOUtils.java:57)
>         at org.apache.hadoop.io.IOUtils.copyBytes(IOUtils.java:85)
>         at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:209)
>         at org.apache.hadoop.fs.FileUtil.copy(FileUtil.java:142)
>         at
> org.apache.hadoop.fs.FileSystem.copyToLocalFile(FileSystem.java:1216)
>         at
> org.apache.hadoop.fs.FileSystem.copyToLocalFile(FileSystem.java:1197)
>         at
> org.apache.hadoop.mapred.JobInProgress.<init>(JobInProgress.java:257)
>         at
> org.apache.hadoop.mapred.JobInProgress.<init>(JobInProgress.java:234)
>         at
> org.apache.hadoop.mapred.JobTracker.submitJob(JobTracker.java:2993)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:508)
>         at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:959)
>         at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:955)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at javax.security.auth.Subject.doAs(Subject.java:396)
>         at org.apache.hadoop.ipc.Server$Handler.run(Server.java:953)
>         at org.apache.hadoop.ipc.Client.call(Client.java:740)
>         at org.apache.hadoop.ipc.RPC$Invoker.invoke(RPC.java:220)
>         at org.apache.hadoop.mapred.$Proxy6.submitJob(Unknown Source)
>         at
> org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:800)
>         at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:730)
>         at
> org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:435)
>         at
> org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:137)
>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
>         at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
>         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)

Vijay Kumar
Syntel | Technical Specialist - Hadoop-SOG-DW
office +91  | mobile +91 8056063943| internal dial :
email [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
[Description: cid:[EMAIL PROTECTED]8D90]<http://www.syntelinc.com/> | [Description: cid:[EMAIL PROTECTED]8D90] <http://www.syntelinc.com/rss>  [Description: cid:[EMAIL PROTECTED]8D90] <http://www.linkedin.com/company/syntel>  [Description: cid:[EMAIL PROTECTED]8D90] <twitter.com/syntel>  [Description: cid:[EMAIL PROTECTED]8D90] <http://www.facebook.com/syntel>  [Description: cid:[EMAIL PROTECTED]8D90] <http://www.youtube.com/syntel>  [Description: cid:[EMAIL PROTECTED]8D90] <http://www.slideshare.net/syntelinc>