There are two problems here with the DDL: Use of delimiter with ORC. ORC is in itself a format so you don't have to provide a delimiter. You would define an external table with a location, also ACID tables cannot be external tables, see here. The proper definition for this table would be: CREATE TABLE FIREWALL_LOGS( time STRING, ip STRING, country STRING, status INT ) CLUSTERED BY (time) into 25 buckets STORED AS ORC TBLPROPERTIES("transactional"="true"); ... View more

Hive uses the MySQL jdbc connector for issuing queries to MySQL. You can turn on logging through the jdbc connection url (append &profileSQL=true&logger=com.mysql.jdbc.log.StandardLogger) you are using to connect to mysql db in hive-site.xml. To turn it on the MySQL server you need to set the following in the my.cnf. general_log = 1 general_log_file = /path/to/query.log See more information here. ... View more

desc <tablename> shows the table definition (including column names with the datatype) while select * from <tablename> shows the data in the table. ... View more

Did you verify the data by viewing this data using beeline on the cluster? Does it show up correctly lining up under the expected columns when you do a select * from <tablename>. You can run desc [extended|formatted] <tablename> to view the metadata for the table. ... View more

Overall information is available across partitions only if you are on HDP-2.6 and using Hive2 which i see you are currently not from your description (1.2.1.2.5). If you are using hive 2 the information would be something like: beeline> desc formatted `test_table`; | Table Parameters: | | | | | COLUMN_STATS_ACCURATE | {\"BASIC_STATS\":\"true\"} | | | numFiles | 3 | | | numRows | 5 | | | rawDataSize | 21 | | | totalSize | 26 | | | transient_lastDdlTime | 1495086467 | In case of Hive 1 unfortunately you will have to run the command per partition and aggregate manually. ... View more

For enabling the SQL Std Auth manually you would need to set the following settings in the hive-site.xml before restarting the HiveServer2. hive.server2.enable.doAs=false hive.security.authorization.enabled=true hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator hive.users.in.admin.role=<admin user> In the above <admin user> would be replaced by the user you want as admin. Note that you can perform admin operations after you connect to your beeline session as the admin user and then run the following command: set role ADMIN; For an Ambari controlled cluster recommendation would be to enable it through toggle on the Hive configs page. ... View more

Can you try adding the property hadoop.security.auth_to_local to hive-site.xml as well, bounce the hive services and then try? ... View more

The official hue rpm that is available with HDP-2.5/2.6 is hue-2.6.1. I don't see anyway to get more recent hue rpms for HDP stack. ... View more