I am wondering if the presence of _SUCCESS file is causing the empty result. Can you try setting property "mapreduce.fileoutputcommitter.marksuccessfuljobs" to false to disable the generation of _SUCCESS file? Just a long shot but might not hurt to debug this.
On Mon, Jul 21, 2014 at 4:47 AM, Timo Walther <fl...@twalthr.com> wrote: > Hi everybody, > > I'm currently working on a compatibility layer that enables using the > HCatOutputFormat with Apache Incubator Flink. I followed the corresponding > wiki page ( > https://cwiki.apache.org/confluence/display/Hive/HCatalog+InputOutput) > for my implementation. I'm now able to execute a job and the > HCatOutputFormat finishes without any exception and stores files like > "_SUCCESS", "part-m-00000" (with reasonable size and as RCFiles) in > "/user/hive/warehouse/my.db/my_table/date=2014-04-07/", however, Hive still > doesn't find any data in the table. When I execute "SELECT * FROM > my_table;" the result is always empty. > > Do I somehow have to register the files I have created before I can access > them within Hive? Or is there anything I could do wrong? > I'm using the Hive version of CDH 5. > > Thanks in advance. > > Regards, > Timo >