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.thong...@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 >
