How did you install Hive (through Ambari or manually)? Can you check /var/log/hive/hivemetastore.log? ... View more

For me the command worked. hive> show partitions tablename; OK load_s=2017-02-22 12%3A21%3A39 hive> alter table tablename drop partition (load_s=timestamp '2017-02-22 12:21:39'); Dropped the partition load_s=2017-02-22 12%3A21%3A39 OK You can potentially use this workaround on other thread. ... View more

Yes, the extension on the filename should not matter as long as you are using the correct file path. ... View more

Thanks, useful to know that its finally been implemented. ... View more

There is no "show views" command in Hive. You use "show tables" and it should list the views as well. However there is an open Apache Hive issue HIVE-1010, that will implement INFORMATION_SCHEMA in Hive which will make it possible to query views exclusively. ... View more

If you ran this using beeline connecting to HS2, can you check the full error stack trace in the hiveserver2.log? ... View more

Can you try the following: ALTER TABLE tablename DROP PARTITION IF EXISTS (load_s=timestamp '2017-02-22 12:21:39'); ... View more

Hive does not support like semantics for drop table, see official DDL semantics here. You will need multiple calls to accomplish this and handle them in an external driver. ... View more

Yes, its possible to import data between Hadoop datastores (HDFS, Hive, HBase) and Oracle. Here is a sample command for import data from HDFS to Oracle. sqoop export --connect jdbc:oracle:thin:@oradb.example.com:1521:ORCL --table bar --username user --password passwd --export-dir /user/test/data Above command assumes that the csv data file to be exported into Oracle is in the HDFS folder /user/test/data and the table "bar" exists in Oracle. Also the csv data and its column sequence matches with that of the Oracle table. ... View more