Re: Create table from orc file

2016-08-04 Thread Johannes Stamminger
Some progress: I could eliminate the error reported in a): the data file needs to be named 00_0 and must be placed in a the directory denoted by the location given at table creation. This is what the error message is about? ;-) Now the situation for a) is the same as for b): Trying to

Re: Create table from orc file

2016-08-03 Thread Marcin Tustin
Correct you need to specify the columns. If you created the file I assume you have a record of them. Someone more familiar with the hive code will have to comment on the exceptions. On Wednesday, August 3, 2016, Johannes Stamminger < johannes.stammin...@airbus.com> wrote: > But doing so I

Re: Create table from orc file

2016-08-03 Thread Johannes Stamminger
But doing so I assume it does not detect the columns on it's own, I have to specify such manually - or am I wrong? The orc file I finally want to work with contains ~28000 columns (513MB size, ~50 rows, 3 structs with 2 of them containing ~14000 fields each) ... The hive documentation for the

Re: Create table from orc file

2016-08-03 Thread Marcin Tustin
Yes. Create an external table whose location contains only the orc file(s) you want to include in the table. On Wed, Aug 3, 2016 at 7:53 AM, Johannes Stamminger < johannes.stammin...@airbus.com> wrote: > Hi, > > > is it possible to write data to an orc file(s) using the hive-orc api and > to >

Create table from orc file

2016-08-03 Thread Johannes Stamminger
Hi, is it possible to write data to an orc file(s) using the hive-orc api and to use such by hive (create a table from it)? Regards This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are