Skip to content

Instantly share code, notes, and snippets.

@gbraccialli
Last active May 9, 2017 17:16
Show Gist options
  • Save gbraccialli/d9fc7c681d350e385058 to your computer and use it in GitHub Desktop.
Save gbraccialli/d9fc7c681d350e385058 to your computer and use it in GitHub Desktop.
hive_table
hive_table where name="default.sample_07@Sandbox"
from hive_table where name='default.sample_07@Sandbox',columns
hive_table where name="default.hortondrivers@Sandbox"
1) hive_db where name = 'default' (Selecting the database knowing the name of the database)
2) hive_table where name='default.table_1@cluster1' (Selecting the table knowing the name of the table)
3) hive_table where name='db2.tab4@cluster1' select owner,name,createTime,comment,tableType (selecting attributes of a table)
4) from hive_table where name='default.table_1@cluster1',columns (listing all the columns of the table)
5) hive_table where db.name = 'default' (listing all tables in the database )
create table test
(a string comment 'coluna a',
b string comment 'coluna b')
comment 'tabela test';
create table test2 comment 'tabela test2' as
select * from sample_07
;
insert into test select code, description from sample_07;
#atlas.DeleteHandler.impl=org.apache.atlas.repository.graph.HardDeleteHandler
#atlas.DeleteHandlerV1.impl=org.apache.atlas.repository.store.graph.v1.HardDeleteHandlerV1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment