HQL存储过程

 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';