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
995 views

1 answer to this question.

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
• 13,490 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
• 26,740 points
1,467 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, 2019 in Big Data Hadoop by anonymous

edited Jun 4, 2019 by Omkar 18,946 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 30, 2018 in Big Data Hadoop by Omkar
• 69,210 points
3,515 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 Dec 1, 2018 in Big Data Hadoop by Omkar
• 69,210 points
5,879 views
+1 vote
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
• 11,380 points
10,556 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
104,207 views
–1 vote
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,390 points
4,260 views
0 votes
1 answer
0 votes
3 answers

How to connect Spark to a remote Hive server?

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

answered Mar 8, 2019 in Big Data Hadoop by Vijay Dixon
• 190 points
12,097 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
• 13,490 points
1,922 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP