hdfs dfs -chmod -R 777 /user/hive/warehouse
-----------------------------------------------------------------------------------------------
declare
v oders.item%type;
begin
select item into v from oders limit 1;
end;
-----------------------------------------------------------------------------------------------
declare
v oders%rowtype;
begin
select * into v from oders limit 1;
DBMS_OUTPUT.PUT_LINE('Item: ' || v.name || ' - ' || v.description);
end;
-----------------------------------------------------------------------------------------------
declare
v oders%rowtype;
begin
execute immediate 'select * from oders limit 1' into v;
DBMS_OUTPUT.PUT_LINE('Item: ' || v.name || ' - ' || v.description);
end;
-----------------------------------------------------------------------------------------------
declare
v oders%rowtype;
cursor c1 for select * from oders;
begin
open c1;
fetch c1 into v;
loop
print '11';
DBMS_OUTPUT.PUT_LINE('Item: ' || v.name || ' - ' || v.description);
end loop;
end;
-----------------------------------------------------------------------------------------------
begin
for v in(select * from oders)
loop
print '1';
DBMS_OUTPUT.PUT_LINE('Item: ' || v.name || ' - ' || v.description);
end loop;
end;
-----------------------------------------------------------------------------------------------
declare
v string;
begin
open cur for 'select c1 from t1';
fetch cur into v;
close cur;
exception when others then
DBMS_OUTPUT.PUT_LINE('ERROR');
end;
------------------update
update table_name set(col1,col2,col3)=(select c1,c2,c3 from dual);
----------------------------create table 分区表
CREATE EXTERNAL TABLE EMP(
name STRING,
salary FLOAT,
subo ARRAY<STRING>,
dedu MAP<STRING,FLOAT>,
addr STRUCT<street:STRING,city:STRING,state:STRING,zip:INT>
)PARTITIONED BY (city STRING,state STRING)
TALPOPERTIES('creator'='mark','date'='2018-06-10')
ROW FORMAT DELIMITED FILEDS TERMINATED BY '\t'
COLLECTION ITEMS BY '\t'
MAP KEYS BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION '/user/hive/warehouse/dir';
--加载数据
LOAD DATA LOCAL INPATH '///' INTO TABLE EMP PARTITION BY(city='US',state='CA');
--------------------------------分桶表
CREATE EXTERNAL TABLE IF NOT EXISTS stocks(
exchange STRING,
symbol STRING,
ymd STRING,
pric_open FLOAT,
price_high FLOAT,
price_low FLOAT,
price_close FLOAT,
volume INT,
price_adj_close FLOAT
) CLUSTERED BY (exchange,symbol)
SORTED BY (ymd ASC) INTO 5 BUCKETS
ROW FORMAT DELIMITED FILEDS TERMINATED BY '\t'
LOCATION '/hive/warehouse/dir';
HQL存储过程
最新推荐文章于 2022-06-17 11:34:03 发布