HKEY_CURRENT_USER (HKCU registry hive)

Help needed!
I’ve read all the basic documentation I found online (StackOverflow, Github, etc.) but nothing helped.
I’m trying to connect to hive(hue) support from my PC using Python. My script:

 Trace (last call):
 File "C:/Users/myuser/Documents/Python/", line 6, in = hive.connect('myconnect', port=10000, username='root').cursor()
 File "C:\Users\myuser\AppData\Local\Continuum\anaconda3\lib\site-packages\pyhive\", line 94,
 wear connection
 Reconnect (*args, **kwargs)
 File "C:\Users\myuser\AppData\Local\Continuum\anaconda3\lib\site-packages\pyhive\", line
 192 if file
 "C:\Users\myuser\AppData\Local\Continuum\anaconda3\lib\site-packages\thrift_sasl\", string
 79, available in message=("Failed to start SASL: %s" % self.sasl.getError()))
 thrift.transport.TTransport.TTransportException: Failed to start SASL process: error in
 sasl_client_start (-4) SASL(-4): mechanism not available: callback not found: 2'

: Python 3.7.4

: Anaconda Inc. connected to win32

impcur = connect(host=”kudu3″, port=21050, database=”yingda_test”, password=None, user=’admin’, use_http_transport=True ).cursor()

I always get an error:
Traceback (Last email after nim): file "/Users/edy/src/PythonProjects/dt-center-algorithm/test/", line 4, and impcur Connect(host= "kudu3", =port=21050, database ="yingda_test", password=None, user='admin', use_http_transport=True ).cursor() file "/usr/local/conda3/envs/py37/lib/python3.7/site-packages/impala/hiveserver2. py", limit 129, in the cursor session is equal to the file self.service.open_session(user, configuration) "/usr/local/conda3/envs/py37/lib/python3.7/site-packages/impala/", line 1187, as part of open_session resp = self._rpc('OpenSession', req, True) file "/usr/local/conda3/envs/py37/lib/python3.7/site -packages /impala/", line 1080, total _rpc response = self._execute(func_name, request, retry_on_http_error) file "/usr/local/conda3/envs/py37/lib/python3.7/site-packages/impala /", line 1142, in _execute .format(self.retries)) impala.error.HiveServer2Error: Retry ez failed after five attempts chen

Why is my code not working in hive?

I’m assuming you’re using HiveServer2, which can be described as the reason why it’s not working. You can use pyhs2 to properly access your hive and sample code is as follows: Warning, you can install python-devel.x86_64 cyrus-sasl-devel.x86_64 before installing pyhs2 with pip. Hope this helps you.

We ran into a problem when using Anaconda to connect to a Hive environment. The Hive decryption is version 3.1.0 of Ambari 2.7.4, which is typically a multi-node cluster. The Python connection to Hive works fine from the RHEL server. But the same version does not connect via Anaconda Windows10. The conda version is probably 4.9.0. The exact errors are given below

TTransportException: SASL cannot be started: b’Error running at sasl_client_start (-4) No sasl(-4): Suggested mechanism: Failed find callback: 2′

The more the better 404 Not Found
an error was qualified when trying to use an ErrorDocument to process the request.

We have a VPN where we manage a Windows Server and Hortonworks based Hadoop distribution installed on multiple data nodes in Redhat.

A set of Python scripts is installed on Windows machines, many of us are trying to access Hive tables available on a given Hadoop cluster.

A lot is open on port 10000 Hive to listen for external requests. window

from an ODBC window on a web connection works fine with the specified mov, but the python script mentioned below usually fails to run with errors.

To do this, we have installed some important packages that are definitely required to connect to Hive as mentioned below;

Please find the page code below:

 from pyhive import hive
from TCLIService.ttypes import TOperationState
Import savings
import pandas to pd
import pyhs2

Cursor means hive.connect(host='dnanoripaihos01.retailaip.local', auth='KERBEROS', port='10000',kerberos_service_name='hive').cursor()
cursor.execute('SELECT * FROM undo LIMIT 50')

When experts run this script, they get the following error:


Tracking (last contact last): File "C:\Users\rekha.b.gaonkar\Desktop\", line 9, inside Cursor - hive.connect(host='dnanoripaihos01.retailaip.local', auth='KERBEROS', port='10000',kerberos_service_name='hive').cursor() File "", line En 94, connect Reconnect (*args, **kwargs) File "", series 192, in __init__ Open the file "", line 79. in message=("Unable to start SASL: %s" % self.sasl.getError())) thrift.transport.TTransport.TTransportException: SASL cannot be started: b'Error in sasl_client_start (-4) SASL(-4): mechanism not available: not found, just call back: 2'

HKEY_CURRENT_USER, often shortened to HKCU, is one of the best of half a dozen registry cools, the most recent core part of the Windows registry.

It contains Windows configuration information, not to mention software specific to the currently logged in user.

For exampleer, different registry values using different keys The registries below the HKEY_CURRENT_USER hive control user-level locations such as installed printers, desktop, display settings, environment variables< /a>, keyboard layout, mapped network drives and more.

Many of the applets settings that you configure in Control Panel were actually stored in this hive in the computer’s system registry.


HKEY_CURRENT_USER is the branch of the Windows registry with the simplest item types to look for in the Registry Editor:

  1. Open Registry Editor. A quick way to do this is to enable regedit in the Run dialog box.

  2. Find HKEY_CURRENT_USER in the Registry Editor in the left pane.

  3. Double-tap , double-click HKEY_CURRENT_USER, or click/tap on the small or plus arrow icon once on the left if you like – expand it.


HKEY_CURRENT_USER can be difficult to find if the editor isStra used you on your computer before you did so because the program redirects you to exactly where you were last. Because it’s present on all computers with the Windows registry, you don’t have to skip HKEY_CURRENT_USER if you can’t find it, but you may need to hide a few things to find it.

Here’s what you can use: On the left side of the registry from the Notepad perspective, scroll down to the largest until you see Computer and HKEY_CLASSES_ROOT. Click the arrow or plus sign to the left of this HKEY_CLASSES_ROOT folder to collapse/collapse this entire hive. The one below is considered HKEY_CURRENT_USER.

Registry Subkey Via HKEY_CURRENT_USER

Here are some duplicate registry keys that you can no longer find in the HKEY_CURRENT_USER hive:

  • HKEY_CURRENT_USER\Control Panel
  • HKEY_CURRENT_USER\Environment
  • HKEY_CURRENT_USER\Credential
  • From layout

  • hkey_current_user\network
  • hkey_current_user\printer
  • hkey_current_user\software
  • hkey_current_user\si theme
  • hkey_current_user\volatile The HKEY_CURRENT_USER hive is separate from the user, the keys and values ​​it contains vary from user to user, so they can also be used on the above machine. This is different from most other Windows registry hives that are global, such as HKEY_CLASSES_ROOT, which contain the same information about all Windows users.

    HKCU Samples

    Here is some information about several preference keys found in the HKEY_CURRENT_USER hive:


    Here are labels, sounds, and descriptions of various Windows features and simply third-party apps such as .

    HKEY_CURRENT_USER\Control Panel

    In particular, \Control Panel\Keyboard controls certain keyboard settings, such as keyboard latency and speed settings, which are typically controlled using the Repeat Delay and Repeat Rate settings in the Control Panel applet.

    The mouse applet is another applet with settings stored in the key HKEY_CURRENT_USER\Control Panel\Mouse. Some options, DoubleClickHeight, includeThere are ExtendedSounds, MouseSensitivity, MouseSpeed, MouseTrails and SwapMouseButtons.

    The other control area of ​​the panel is for the mouse pointer only and is located in the “Cursors” section. This is where the names are stored along with the default physical file locations and custom cursors. Windows uses silent, simply animated cursor files that have the specific extensions CUR and ani file respectively, so most of the cursor programs found here refer to files related to these display types , in %. The SystemRoot%\cursors\ folder.

    This is indeed true of the Control button hkcu Panel Desktop which describes many desktop related settings in views like WallpaperStyle which describes whether to center the wallpaper directly or stretch this task across the screen. ScreenSaveTimeOut and MenuShowDelay.