Some progress: I could eliminate the error reported in a): the data file needs
to be named 000000_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 fetch data by
select * from CFA1_Fan_Speed_DMC limit 1;
results in
Error: java.io.IOException: java.io.IOException: ORC does not support type
conversion from file type timestamp (1) to reader type
struct<normalizedTime:timestamp,RAW:bigint,ENG:float> (1) (state=,code=0)
But if I create a comparable table within hive, things do work:
create table x(y struct<a:timestamp,b:bigint,c:float>);
insert into x select named_struct('a', current_timestamp, 'b', bigint(42),
'c', float(4.2)) from dummy limit 1;
select * from x;
+-------------------------------------------------+--+
| x.y |
+-------------------------------------------------+--+
| {"a":"2016-08-04 14:49:01.636","b":42,"c":4.2} |
+-------------------------------------------------+--+
The tables look similar:
describe CFA1_Fan_Speed_DMC;
+-----------+--------------------------------------------------------
+----------+--+
| col_name | data_type | comment
|
+-----------+--------------------------------------------------------
+----------+--+
| record | struct<normalizedTime:timestamp,RAW:bigint,ENG:float> |
|
+-----------+--------------------------------------------------------
+----------+--+
describe x;
+-----------+---------------------------------------+----------+--+
| col_name | data_type | comment |
+-----------+---------------------------------------+----------+--+
| y | struct<a:timestamp,b:bigint,c:float> | |
+-----------+---------------------------------------+----------+--+
So does anybody have an idea what might be wrong with my external table
access? Anything that I could give a try?
This email (including any attachments) may contain confidential and/or
privileged information or information otherwise protected from disclosure. If
you are not the intended recipient, please notify the sender immediately, do
not copy this message or any attachments and do not use it for any purpose or
disclose its content to any person, but delete this message and any attachments
from your system. Astrium and Airbus Group companies disclaim any and all
liability if this email transmission was virus corrupted, altered or falsified.
---------------------------------------------------------
Airbus DS GmbH
Vorsitzender des Aufsichtsrates: Bernhard Gerwert
Geschäftsführung: Evert Dudok (Vorsitzender), Dr. Lars Immisch, Dr. Michael
Menking, Dr. Johannes von Thadden
Sitz der Gesellschaft: München - Registergericht: Amtsgericht München, HRB Nr.
107 647
Ust. Ident. Nr. /VAT reg. no. DE167015356
