SHARE
TWEET

Untitled

a guest Jun 18th, 2019 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table employees (
  2.  name   string,
  3.  salary  float,
  4.  subordinated array<string>,
  5.  deductions map<string,float>,
  6.  address  struct<street:string,city:string,state:string,zip:int>
  7.  ) partitioned by (country string, state string)
  8.      
  9. n=1000000
  10. ID=rand(10, n)
  11. x=rand(1.0, n)
  12. t=table(ID, x)
  13. db=database("C:/DolphinDB/Data/rangedb", RANGE,  0 5 10)
  14.  
  15. pt = db.createPartitionedTable(t, `pt, `ID)
  16. pt.append!(t)
  17.  
  18. pt=loadTable(db,`pt)
  19. select count(x) from pt;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top