hue supported multiple mysql source

[luhea]

Hello，I havae two mysql source want use them in an Hue Server，what should i do？

[Meepoljdx]

You can try to config rdbms to achieve this goal, this is my way to connect two PostgreSQL Server:

[notebook]
...
  [[interpreters]]
    [[[postgresql2]]]
      name=PostgreSQL2
      interface=rdbms

    [[[postgresql3]]]
      name=PostgreSQL3
      interface=rdbms

[librdbms]
...
  [[databases]]
    [[[postgresql2]]]
      nice_name = "PostgreSQL2"
      name=hue
      engine=postgresql_psycopg2
      host=bigdata-m-002
      port=5432
      user=postgres
      password=XXX
      options={}
      schema=public

    [[[postgresql3]]]
      nice_name = "PostgreSQL3"
      name=metadata
      engine=postgresql_psycopg2
      host=XXXX
      port=5832
      user=postgres
      password=XXXX
      options={}
      schema=public

This is the PostgreSQL2

This is the PostgreSQL3

You can also see this http://gethue.com/custom-sql-query-editors/

[luhea]

Hello，Meepoljdx. can i config multiple hive？what should i do?

[Meepoljdx]

Sorry, I haven't tried, :(. May be you can try jdbc url. But I don't know if hue will be able to support it