Python Impala Beispiele

Beispiel #1

Datei: api.py Projekt: zzzharpreet/hue

from desktop.lib.exceptions_renderable import PopupException

LOG = logging.getLogger(__name__)

# TODO: automatically load modules from lib module
# TODO: offer to white/black list available connector classes
CONNECTOR_TYPES = [
    {
        'nice_name': connector.NAME,
        'dialect': connector.TYPE,
        'interface': connector.INTERFACE,  # interfaces = ['int1', 'int2'...]
        'settings': connector.PROPERTIES,
        'id': None,
        'category': 'editor',
        'description': ''
    } for connector in [Impala(), Hive()]
]

CONNECTOR_TYPES += [
    {
        'nice_name':
        "Hive Tez",
        'dialect':
        'hive-tez',
        'interface':
        'hiveserver2',
        'settings': [
            {
                'name': 'server_host',
                'value': ''
            },

Beispiel #2

Datei: api.py Projekt: jinwensc/hue

LOG = logging.getLogger(__name__)


# TODO: automatically load modules from lib module
# TODO: offer to white/black list available connector classes
CONNECTOR_TYPES = [{
    'name': connector.NAME,
    'type': connector.TYPE,
    'interface': connector.INTERFACE,
    'settings': connector.PROPERTIES,
    'id': None,
    'category': 'engines',
    'description': ''
    }
  for connector in [
    Impala(), Hive()
  ]
]

CONNECTOR_TYPES += [
  {'name': "Hive Tez", 'type': 'hive-tez', 'settings': [{'name': 'server_host', 'value': ''}, {'name': 'server_port', 'value': ''},], 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Hive LLAP", 'type': 'hive-llap', 'settings': [{'name': 'server_host', 'value': ''}, {'name': 'server_port', 'value': ''},], 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Druid", 'type': 'druid', 'settings': [{'name': 'connection_url', 'value': 'druid://druid-host.com:8082/druid/v2/sql/'}], 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Kafka SQL", 'type': 'kafka-sql', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},
  {'name': "SparkSQL", 'type': 'spark-sql', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Presto", 'type': 'presto', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Athena", 'type': 'athena', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Redshift", 'type': 'redshift', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Big Query", 'type': 'bigquery', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},
  {'name': "Oracle", 'type': 'oracle', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},
  {'name': "SQL Database", 'type': 'sql-alchemy', 'settings': {}, 'id': None, 'category': 'engines', 'description': ''},

Beispiel #3

LOG = logging.getLogger(__name__)


# TODO: automatically load modules from lib module
# TODO: offer to white/black list available connector classes
CONNECTOR_TYPES = [{
    'nice_name': connector.NAME,
    'dialect': connector.TYPE,
    'interface': connector.INTERFACE,
    'settings': connector.PROPERTIES,
    'id': None,
    'category': 'editor',
    'description': ''
    }
  for connector in [
    Impala(), Hive()
  ]
]
CONNECTOR_TYPES += [
  {'nice_name': "Hive Tez", 'dialect': 'hive-tez', 'interface': 'hiveserver2', 'settings': [{'name': 'server_host', 'value': ''}, {'name': 'server_port', 'value': ''},], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Hive LLAP", 'dialect': 'hive-llap', 'interface': 'hiveserver2', 'settings': [{'name': 'server_host', 'value': ''}, {'name': 'server_port', 'value': ''},], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Druid", 'dialect': 'sql-druid', 'interface': 'sqlalchemy', 'settings': [{'name': 'url', 'value': 'druid://druid-host.com:8082/druid/v2/sql/'}], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Kafka SQL", 'dialect': 'kafka-sql', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "SparkSQL", 'dialect': 'spark-sql', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "MySQL", 'dialect': 'sql-mysql', 'interface': 'sqlalchemy', 'settings': [{'name': 'url', 'value': 'mysql://*****:*****@mysq-host:3306/hue'}], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Presto", 'dialect': 'presto', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Athena", 'dialect': 'athena', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Redshift", 'dialect': 'redshift', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Big Query", 'dialect': 'bigquery', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "Oracle", 'dialect': 'oracle', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},
  {'nice_name': "SQL Database", 'dialect': 'sql-alchemy', 'interface': 'sqlalchemy', 'settings': [], 'id': None, 'category': 'editor', 'description': ''},

Beispiel #4

Datei: api.py Projekt: evanzh7/goumang

from desktop.lib.connectors.lib.hive import Hive
from desktop.lib.exceptions_renderable import PopupException

LOG = logging.getLogger(__name__)

# TODO: automatically load modules from lib module
# TODO: offer to white/black list available connector classes
CONNECTOR_TYPES = [{
    'name': connector.NAME,
    'type': connector.TYPE,
    'interface': connector.INTERFACE,
    'settings': connector.PROPERTIES,
    'id': None,
    'category': 'engines',
    'description': ''
} for connector in [Impala(), Hive()]]

CONNECTOR_TYPES += [
    {
        'name':
        "Hive Tez",
        'type':
        'hive-tez',
        'settings': [
            {
                'name': 'server_host',
                'value': ''
            },
            {
                'name': 'server_port',
                'value': ''