Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Atlas 0.5 and Alter Scripts

avatar
New Member

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).