Cannot connect to Hive from MicroStrategy BI tool

0 votes

I am using MicroStrategy BI tool. I want to connect Apache Hive with the Microstrategy tool. So, I started the hiveserver 2 & Hadoop daemons. I checked with sudo jps, all of the daemons are running. I there a way to connect to the BI tool without any authentication (user & password).

In MicroStrategy I followed 'Add New Datasource->Hadoop->DSN-less Datasource->Apache Hive'.  While giving any user & password, it is throwing an error. 

May 8, 2018 in Big Data Hadoop by mac113
124 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

The problem is with your hive authentication. You need to configure your hive authentication. Go to hive-site.xml file in the conf directory present in hive home.

There you have to add hive.server2.authentication property with the value as NONE. 

  <property>
    <name>hive.server2.authentication</name>
    <value>NONE</value>
    <description>
      Expects one of [nosasl, none, ldap, kerberos, pam, custom].
    </description>
  </property>

Here you can specify the value as

  • NONE
  • LDAP
  • KERBEROS
  • CUSTOM
  • PAM
  • NOSASL
answered May 8, 2018 by Shubham
• 12,710 points

Related Questions In Big Data Hadoop

0 votes
1 answer

How to create smaller table from big table in HIVE?

You could probably best use Hive's built-in sampling ...READ MORE

answered Sep 24, 2018 in Big Data Hadoop by digger
• 27,620 points
85 views
0 votes
2 answers

How to get column names from Hive table?

To get all the columns of a ...READ MORE

answered Jun 4 in Big Data Hadoop by anonymous

edited Jun 4 by Omkar 777 views
0 votes
1 answer

Hadoop Job Tracker problem. I cannot connect to http://localhost:50030/

I think you are using new version ...READ MORE

answered Nov 29, 2018 in Big Data Hadoop by Omkar
• 66,880 points
274 views
0 votes
1 answer

Unable to move Hadoop Hive tables from Source to Destination.

First, check the permissions of HDFS Directory ...READ MORE

answered Nov 30, 2018 in Big Data Hadoop by Omkar
• 66,880 points
205 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 9,310 points
1,817 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
8,983 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
646 views
0 votes
1 answer
0 votes
2 answers

How to connect Spark to a remote Hive server?

JDBC is not required here. Create a hive ...READ MORE

answered Mar 8 in Big Data Hadoop by Vijay Dixon
• 180 points
883 views
0 votes
1 answer

How do I connect my Spark based HDInsight cluster to my blob storage?

Go through this blog: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-hadoop-use-blob-storage#access-blobs I went through this ...READ MORE

answered Apr 15, 2018 in Big Data Hadoop by Shubham
• 12,710 points
451 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.