In [5]:

    

import jaydebeapi
import pandas as pd
import numpy as np



conn = jaydebeapi.connect("com.asterdata.ncluster.Driver",
        'jdbc:ncluster://host:port/beehive',['user', 'pw']
        ,'noarch-aster-jdbc-driver.jar')

#def exec_sql(sql):
#    curs = conn.cursor()
#    curs.execute(sql)
#    curs.close()


    

In [28]:

    

sql = """ 
select * from nc_system.nc_all_schemas
""" 

table = pd.read_sql(sql,conn)