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
203 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,300 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,550 points
206 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 2,612 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
• 67,660 points
570 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
• 67,660 points
680 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
• 10,710 points
3,306 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
16,302 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
1,188 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 in Big Data Hadoop by Vijay Dixon
• 180 points
1,485 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,300 points
693 views