单表
新建表
CREATE TABLE IF NOT EXISTS article(
id INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
author_id INT(10) UNSIGNED NOT NULL,
category_id INT(10) UNSIGNED NOT NULL,
views INT(10) ...
内表数据加载
创建表时加载
create table newtable as select col1,col2 from oldtable
hive> create table testNew as select name,addr from testtable;
hive> select * from testN...
###内表数据加载####创建表时加载create table newtable as select col1,col2 from oldtablehive> create table testNew as select name,addr from testtable;hive> select * from testNew;OKliguodon...
http://www.blogjava.net/decode360/archive/2008/10/16/286802.html
create or replace type person as object( name varchar2(10), sex varchar2(2), birthday date, age number(2));
两种创建对象表的...
