Hive minecraft server commands how to#
Hive minecraft server commands install#

or to use the connection to make a Pandas dataframe: import pandas as pdДf = pd.read_sql('SELECT cool_stuff FROM hive_table', conn)

You can just straight-up query: cursor = conn.cursor()Д¬ursor.execute('SELECT cool_stuff FROM hive_table')

Hive minecraft server commands how to#

Now that you have the hive connection, you have options how to use it. On a Mac SASL should be available if you've installed xcode developer tools ( xcode-select -install in Terminal)ДЄfter installation, you can connect to Hive like this: from pyhive import hiveД¬onn = hive.Connection(host='YOUR_HIVE_HOST', port=PORT, username='YOU') For Windows there are some options on GNU.org, you can download a binary installer.

Hive minecraft server commands install#

Install the package libsasl2-dev using apt-get or yum or whatever package manager for your distribution. If you're on Linux, you may need to install SASL separately before running the above. Please note that although you install the library as PyHive, you import the module as pyhive, all lower-case. To install you'll need these libraries: pip install sasl I believe the easiest way is to use PyHive. : Invalid method name: 'execute'Д«ut inspecting the ThriftHive.py file reveals the method execute within the Client class. I received the following error: Traceback (most recent call last):ДЇile '/usr/lib/hive/lib/py/hive_service/ThriftHive.py', line 68, in executeДЇile '/usr/lib/hive/lib/py/hive_service/ThriftHive.py', line 84, in recv_execute

Protocol = TBinaryProtocol.TBinaryProtocol(transport)Д¬lient.execute('CREATE TABLE test(c1 int)') Transport = TTransport.TBufferedTransport(transport) So I set it up like so: from thrift import ThriftДЇrom thrift.protocol import TBinaryProtocol The default Hive Thrift port is 9083, which stopped the hanging. Next the port in the example was 10000, which when I tried caused the program to hang. I can then do the imports as listed in the link, with the exception of from hive import ThriftHive which actually need to be: from hive_service import ThriftHive When I add this to /etc/profile: export PYTHONPATH=$PYTHONPATH:/usr/lib/hive/lib/py