I am able to connect to Beeline, created a database, and use that database. But got the following error when trying to create a table. The create-table statement syntax is correct.
Connected to: Apache Hive (version 3.1.0.3.1.0.0-78)
Driver: Hive JDBC (version 3.1.0.3.1.0.0-78)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.0.3.1.0.0-78 by Apache Hive
0: jdbc:hive2://name01.abc.local:2181,data01> Create table blah blah;
Error: Error while compiling statement: FAILED: HiveAuthzPluginException Failed to retrieve roles for hive: Metastore Authorization api invocation for remote metastore is disabled in this configuration. Run commands via jdbc/odbc clients via HiveServer2 that is using embedded metastore. (state=42000,code=40000)
As far as I know, this is related to Hive Metastore, so I went to Ambari and found the following setting in Hive.
hive.security.metastore.authenticator.manager
org.apache.hadoop.hive.ql.security.HadoopDefaultMetastoreAuthenticator
Any suggestion?