Jdbc HiveData sources API

Register a data source

POST /api/jdbc_hive_data_sources

Parameters

Name	Description
name	Name to show Chorus users for JDBC Hive data source
description	Description of data source
host	Host IP or address of data source
db_username	Username for connection to data source (if non-kerberos)
db_password	Password for connection to data source (if non-kerberos)
hive_kerberos	Is Kerberos enabled (true or false)
hive_hadoop_version	Hive Hadoop version ("Cloudera CDH5", "HortonWorks HDP 2.2-2.3", "MapR4")
hive_kerberos_principal	Hive principal (only needed if hive_kerberos is set to true)
hive_kerberos_keytab_location	Hive Keytab Location (only needed if hive_kerberos is set to true)
shared	true to allow anyone to connect using these credentials, false to require individuals to enter their own credentials

Request

Headers

Host: example.org
Content-Type: application/x-www-form-urlencoded
Cookie: _session_id=Y1I5cXpBMGZzcFJtZFM2dzRhRFNoSHNaR1lScjFSS3pwNUdNTGt2U0JGU2RaeURuYkFJMk9FMHVCNVc2eHNZYW5sc2J4b05hclU5M1lpQktrcmRKUE1qZFBScE8rRUsrSzVDNEtlTldhakg5d0lleDI3TW0vVllUendGWE8rZDNOMzRudHlXbnpRUUNOVFhFUllwUnpsU2dnMEZFOUpEU2REeG9ZZlpjTkJVbXFTcVgrOWdOK1VzUTA5NnlYQmlPRzJ1RmVRbEhQK05WUlJsZFExTmRrcnVYMTdoalRrOHkwY0RmbU9wUVZkci96UmxGY292dC9SV2F3K1M2cWkzdWhQOUdkaHRLWjJpTlh6ai9TdDRoT1NuV1J3UEE2YTZ0SGE3YlVvRmRNMGt2cDZ5cHJZYW02UjJLMlpuL2Z1UVpGQkc1R0huUUFkRzc3bFlMb0dDek9LRmpXTFpvZHZwTmsrVTZNUmdZaFFrdGJyWVZVSUg0V0JGWGFjTTNyUU1IUDR1bVg1ZXZzQ2lvaFFlbFNJUWlsQTVSd01ycjZqQWw5bFFWdDBvTDVPMD0tLTRYdDN4RDk1eEFQeGJtNnZtTktHdXc9PQ%3D%3D--a49ca2d2dc7a847f7627fcfb4db70dd0a311140f

Route

POST /api/jdbc_hive_data_sources

Body

Response

Headers

X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff
Content-Type: application/json; charset=utf-8
ETag: W/"7968c73c05228f1b67290fc6fb1b51c0"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=YmZRVWwzRnRodytUUVlxVEthS0tZYlNtbFB6bWZKb1VSQXliSGdnWk1IdVpIQ3Y2NEZzWUJlMFI4UXdhQjgwQkg3NGtmV0grSDg0akJmMkw3dlNtNlk0eUNTVzJxMFFrbnRRV3VtSmROUithVGtEWlBvZ0dWRGthaFZyRFhZcVg5RTVpV1BoZVFaTXJYUFpHOE4xMXFldS9rdktRVXdWVTRnZ1MydEtWNVdXcjh5SitUV0Rmb2Jkd25peEJzd0tkaUxzdmdsYzJ4QkdHRkJZQXhwc1d0bGVhUkZTdmNIcjVzOHZydnA3cG90VHhQMEY0UVllSFc3VlJDTjRJaGlNajdndk1WT0piRjZMUTdJNGg5RnFCemdQU3dTKzNnM0xoMEt2TFg2RG1kaUNlNnMrNlFxNEUraUdRK0xrWWhsTHlVdjBkM0FIVGVkYlArdFE1YUZZN0Fha2IycW9MbTZkR0VWbnFrRm9QdExkcTd2NnhkWkl6YkJwdzluQ1NIaDBKNnZaSDBlSW8vSzZwM2NEOTZZVlg2U0MxUmphNDEySEZTd3E5NHNuYkQyNjQ2Z1EySFBIUXBVL1NjOURUYXhlMy0tbWtpTHlxYVhIc3ZFL3ltbWU5Wkt1UT09--796cefda6fef9335df83356725b291e9f324cf80; path=/; HttpOnly
X-Request-Id: dc13a25d-989c-4295-9f3d-9eb61e362ea1
X-Runtime: 0.250656
Content-Length: 1290

Status

201 Created

Body

{"response":{"id":1000024,"name":"Hive Source","entity_type":"jdbc_hive_data_source","is_deleted":null,"shared":true,"owner_id":1000006,"version":null,"is_hawq":null,"state":"online","public":false,"host":"hive.hive","port":null,"ssl":false,"online":true,"db_name":null,"description":"Bzzz Bzzz","db_username":"default","owner":{"id":1000006,"username":"owner","legacy_password_digest":null,"created_at":"2019-04-03T22:09:26Z","updated_at":"2019-04-03T22:10:19Z","first_name":"searchquery","last_name":"User_1","email":"chorususer282295@alpinenow.com","title":"Chief Data Scientist","dept":"Corporation Corp., Inc.","notes":"One of our top performers","admin":false,"deleted_at":null,"image_file_name":"User.png","image_content_type":"image/png","image_file_size":39100,"image_updated_at":"2019-04-03T22:09:26Z","legacy_password_salt":"","legacy_id":null,"subscribed_to_emails":true,"developer":false,"auth_method":"internal","ldap_group_id":null,"user_type":"analytics_developer","roles":["data_admin"],"session_index":null,"active_license":true,"deactivated_at":null,"is_siteadmin":false},"tags":[],"schema_blacklist":[],"hive":false,"hive_kerberos":false,"hive_kerberos_principal":"xxxx","hive_hadoop_version":"Cloudera CDH5","hive_kerberos_keytab_location":"xxxx","complete_json":true}}