Support Questions

Find answers, ask questions, and share your expertise

Atlas 0.5 and Alter Scripts

avatar
Contributor

Does Atlas 0.5 support ALTER statements in Hive Bridge or is it reflected in a later version?

These statements don't seem to be reflected in schema for table.

ALTER TABLE test SET TBLPROPERTIES ("comment"="test comment");

ALTER TABLE test CHANGE a a string comment 'test column comment'; ALTER TABLE test add COLUMNS (b string comment 'test column comment 2');

In addition, transient_lastDdlTime is set to Jan 17, 1970.

This statement shows updated metadata. CREATE TABLE test2 (b string comment 'test column comment 2');

thanks,

Andrew

1 ACCEPTED SOLUTION

avatar

Hi @Andrew Sears,

Here are the hive operations that are captured in Atlas 0.6 : create database, create table, create view, CTAS, load, import, export, query, alter table rename and alter view rename. (source here)

The operations that are not supported in v0.6 are not supported in V0.5 neither.

A new version (v0.7) is available today and support more operation in Hive Bridge and introduce new bridges (Sqoop, Falcon and Storm).

View solution in original post

1 REPLY 1

avatar

Hi @Andrew Sears,

Here are the hive operations that are captured in Atlas 0.6 : create database, create table, create view, CTAS, load, import, export, query, alter table rename and alter view rename. (source here)

The operations that are not supported in v0.6 are not supported in V0.5 neither.

A new version (v0.7) is available today and support more operation in Hive Bridge and introduce new bridges (Sqoop, Falcon and Storm).