hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From patcharee <Patcharee.Thong...@uni.no>
Subject Re: query orc file by hive
Date Fri, 13 Nov 2015 11:59:08 GMT
Hi,

It work with non-partition ORC, but does not work with (2-column) 
partitioned ORC.

Thanks,
Patcharee


On 09. nov. 2015 10:55, Elliot West wrote:
> Hi,
>
> You can create a table and point the location property to the folder 
> containing your ORC file:
>
>     CREATE EXTERNAL TABLE orc_table (
>       <schema>
>     )
>     STORED AS ORC
>     LOCATION '/hdfs/folder/containing/orc/file'
>     ;
>
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable
>
> Thanks - Elliot.
>
> On 9 November 2015 at 09:44, patcharee <Patcharee.Thongtra@uni.no 
> <mailto:Patcharee.Thongtra@uni.no>> wrote:
>
>     Hi,
>
>     How can I query an orc file (*.orc) by Hive? This orc file is
>     created by other apps, like spark, mr.
>
>     Thanks,
>     Patcharee
>
>


Mime
View raw message