Try this simple external table creation in beeline (check first that that it connects OK)
*use default;drop table if exists trips;CREATE EXTERNAL TABLE `TRIPS`( `bike_nr` string, `duration` int, `start_date` string, `start_station` string, `end_station` string)PARTITIONED BY ( `year` int, `month` string)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'LOCATION '/test/text/trips';desc trips;!exit* run the code bl -f create_externat_table_trips.hql No rows affected (0.018 seconds) CREATE EXTERNAL TABLE `TRIPS`( `bike_nr` string, `duration` int, `start_date` string, `start_station` string, `end_station` string) PARTITIONED BY ( `year` int, `month` string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION '/test/text/trips' INFO : Semantic Analysis Completed INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=hduser_20160511001257_b2b612dd-d007-406d-a49c-83e8352a6ac1); Time taken: 0.009 seconds INFO : Executing command(queryId=hduser_20160511001257_b2b612dd-d007-406d-a49c-83e8352a6ac1): CREATE EXTERNAL TABLE `TRIPS`( `bike_nr` string, `duration` int, `start_date` string, `start_station` string, `end_station` string) PARTITIONED BY ( `year` int, `month` string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION '/test/text/trips' INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hduser_20160511001257_b2b612dd-d007-406d-a49c-83e8352a6ac1); Time taken: 0.028 seconds INFO : OK +--------------------------+-----------------------+-----------------------+--+ | col_name | data_type | comment | +--------------------------+-----------------------+-----------------------+--+ | bike_nr | string | | | duration | int | | | start_date | string | | | start_station | string | | | end_station | string | | | year | int | | | month | string | | | | NULL | NULL | | # Partition Information | NULL | NULL | | # col_name | data_type | comment | | | NULL | NULL | | year | int | | | month | string | | +--------------------------+-----------------------+-----------------------+--+ 13 rows selected (0.13 seconds) 0: jdbc:hive2://rhes564:10010/default> Closing: 0: jdbc:hive2://rhes564:10010/default HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 10 May 2016 at 21:25, Margus Roo <mar...@roo.ee> wrote: > Hi again > > I opened hive (an old client) > > And exactly the same create external table .... location [paht in hdfs to > place where are loads of files] works and the same DDL does not work via > beeline. > > Margus (margusja) Roohttp://margus.roo.ee > skype: margusja+372 51 48 780 > > On 10/05/16 23:03, Margus Roo wrote: > > Hi > > Can someone explain or provide documentation how Hive creates external > tables? > > I have problem with creating external table in case I am pointing location > in hdfs in to directory where are loads of files. Beeline just hangs or > there will be other errors. > > In case I point location in to the empty directory then hive creates table. > > > So does hive looks into files during creating external table? > > I can not find any documentation explaining it. > > -- > Margus (margusja) Roohttp://margus.roo.ee > skype: margusja+372 51 48 780 > > >
