Member since
07-09-2019
422
Posts
97
Kudos Received
58
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
427 | 07-06-2025 05:24 AM | |
443 | 05-28-2025 10:35 AM | |
2154 | 08-26-2024 08:17 AM | |
2754 | 08-20-2024 08:17 PM | |
1134 | 07-08-2024 04:45 AM |
09-04-2019
10:28 AM
1 Kudo
Jdbc interpreter is will take default queue to run a job.
To run the job in specific queue add the queue name in hive.url property in JDBC interpreter settings as shown below
hive.url=jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=<Queue Name>
EXAMPLE:
hive.url= jdbc:hive2://c186-node2.-labs.com:2181,c186-node3.-labs.com:2181,c186-node4.-labs.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=sai
Where sai is my queue name.
To check and confirm execute below query in zeppelin using JDBC interpreter and check-in Yarn Resource manager UI
%jdbc(hive)
show databases;
use <database name>;
show tables;
select count (*) from <table name>;
... View more
Labels:
04-16-2019
12:12 PM
1 Kudo
@Manish Roy you need to enable spnego authentication to access webUI after enabling Kerberos ,you can refer to the following article https://community.hortonworks.com/articles/28537/user-authentication-from-windows-workstation-to-hd.html
... View more
01-11-2019
01:04 AM
1 Kudo
@Divya Thaore Are you see any errors in Browser Inspect element , Also check ambari-server logs
... View more
01-10-2019
03:15 PM
1 Kudo
@Divya Thaore 502 Bad Gateway error is usually indicating a networking error, Try restart of the browser or try accessing from Incognito mode
... View more
01-10-2019
03:11 PM
@rajendra use the following to compute the total # of tables you have in Hive. hive -e "show databases" >db3.out;cat db3.out | while read line; do hive -e "use $line;show tables" >> tables3.out;done; cat tables3.out | wc -l
... View more
01-10-2019
02:04 PM
1 Kudo
@Mickke SemSan Try moving /etc/ranger/<Repository name> on namenode to some location and restart Ranger.
... View more
01-02-2019
02:44 PM
1 Kudo
@rajendra check fs.trash.interval time in hdfs , files deleted completely after the trash interval time. you can restore before trash.interval time
... View more
12-28-2018
12:59 PM
@Sedat Kestepe no it is not related to mainboard changed
... View more
12-28-2018
11:57 AM
@Sedat Kestepe this issue occurs when Java is restricting the TLSv1 used by the Ambari Agents. By default, ambari-agent connects to TLSv1, unless specified by force_https_protocol=PROTOCOL_TLSv1_2 in ambari-agent.ini.
... View more
12-28-2018
11:48 AM
1 Kudo
@rajendra babu
From hdp 2.6.3 zeppelin store notebooks under hdfs location:
/user/zeppelin/notebook/ , as you have deleted notebook you can re-store
it from trash. Check if that notebook exists under trash directory or not
... View more