Strategy ONE
Starting in MicroStrategy 2021 Update 4, Hadoop Gateway is no longer supported.
Known Issues
Symptom
In Strategy Web, users have an expansion in the variety of data sources to which they can connect. These new options are under Add External Data. A user with Web Reporter, Web Analyst, and Web Professional privileges will receive a "You do not have enough privileges to perform this operation" error when trying to import a table from a data source. This is due to the fact that the user privilege "Access data from Databases, Google BigQuery, BigData, OLAP, BI tools" is not the only privilege needed. Creating a data source object to import Tables is considered an Administrator Privilege.
Symptom
There are persisting tables in the Hive Metastore when the Strategy Hadoop Gateway service starts. In the log file you can see that the Strategy Hadoop Gateway service is trying to modify the structure of some Metastore tables (such as DBS tables). When it tries to commit the transaction, an error is produced and a rollback operation is generated.
Symptom
Text columns in the parquet file created by Impala are loaded as binaries.
Related Topics
Introduction to the MicroStrategy Hadoop Gateway
How to Deploy the Strategy Hadoop Gateway
How to Start the MicroStrategy Hadoop Gateway