[ 
https://issues.apache.org/jira/browse/HIVE-29178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Denys Kuzmenko updated HIVE-29178:
----------------------------------
    Description: 
RestCatalog example:

{code:java}
CREATE CATALOG [IF NOT EXISTS] <catalog_name>
PROPERTIES (
  'type'='iceberg',
  'catalog-type'='rest',
  'uri'='https://iceberg-with-rest:8181/',
  'client.impl'='org.apache.iceberg.hive.client.HiveRESTCatalogClient'
);
{code}

Hive example
{code}
CREATE CATALOG [IF NOT EXISTS] <catalog_name>
PROPERTIES (
  'type'='iceberg',
  'catalog-type'='hive',
  'uri'='thrift://localhost:9083',
  'warehouse'='hdfs://nn:8020/warehouse/path'
);
{code}

need to extend current schema:
{code}
CREATE TABLE IF NOT EXISTS `CATALOG_PARAMS` (
  `CTLG_ID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(180) NOT NULL,
  `PARAM_VALUE` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`CTLG_ID`,`PARAM_KEY`),
{code}


  was:
RestCatalog example:

{code:java}
CREATE CATALOG [IF NOT EXISTS] <catalog_name>
PROPERTIES (
  'type'='iceberg',
  'catalog-type'='rest',
  'uri'='https://iceberg-with-rest:8181/',
  'client.impl'='org.apache.iceberg.hive.client.HiveRESTCatalogClient'
);
{code}

Hive example
{code}
CREATE CATALOG [IF NOT EXISTS] <catalog_name>
PROPERTIES (
  'type'='iceberg',
  'catalog-type'='hive',
  'uri'='thrift://localhost:9083',
  'warehouse'='hdfs://nn:8020/warehouse/path'
);
{code}



> Add Catalog properties support
> ------------------------------
>
>                 Key: HIVE-29178
>                 URL: https://issues.apache.org/jira/browse/HIVE-29178
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Denys Kuzmenko
>            Priority: Major
>
> RestCatalog example:
> {code:java}
> CREATE CATALOG [IF NOT EXISTS] <catalog_name>
> PROPERTIES (
>   'type'='iceberg',
>   'catalog-type'='rest',
>   'uri'='https://iceberg-with-rest:8181/',
>   'client.impl'='org.apache.iceberg.hive.client.HiveRESTCatalogClient'
> );
> {code}
> Hive example
> {code}
> CREATE CATALOG [IF NOT EXISTS] <catalog_name>
> PROPERTIES (
>   'type'='iceberg',
>   'catalog-type'='hive',
>   'uri'='thrift://localhost:9083',
>   'warehouse'='hdfs://nn:8020/warehouse/path'
> );
> {code}
> need to extend current schema:
> {code}
> CREATE TABLE IF NOT EXISTS `CATALOG_PARAMS` (
>   `CTLG_ID` bigint(20) NOT NULL,
>   `PARAM_KEY` varchar(180) NOT NULL,
>   `PARAM_VALUE` varchar(4000) DEFAULT NULL,
>   PRIMARY KEY (`CTLG_ID`,`PARAM_KEY`),
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to