thanx again! That worked fine, too.
i now found that a hive table does not refer to its own hadoop file, so my table is stored like this:
Permission Owner Group Size Replication Block Size Name
-rwxrwxrwx hue hdfs 17.78 KB 1 32.63 MB BACK_130530_0756_EDW_RETAIL_BEWEGUNGEN_PART51.DEL
-rwxr-xr-x hue hue 3.21 MB 1 32.63 MB BACK_130530_0804_EDW_RETAIL_BEWEGUNGEN_PART52.DEL
-rwxr-xr-x hue hue 30.06 MB 1 32.63 MB BACK_130530_0809_EDW_RETAIL_BEWEGUNGEN_PART53.DEL
-rwxr-xr-x hue hue 39.41 MB 1 32.63 MB BACK_130530_0813_EDW_RETAIL_BEWEGUNGEN_PART54.DEL
-rwxr-xr-x hue hue 23.78 MB 1 32.63 MB BACK_130530_0819_EDW_RETAIL_BEWEGUNGEN_PART55.DEL
so it is stored in 6 Blocks, although 3 would be enough.
Why is it, that a hive table does not generate a new hadoop file, so that it inserts new data at the end of the file? I might have read that this is possible in Hadoop 2.0. ISn’t it?