資源描述:
《ODPS最新SQL參考手冊》由會員上傳分享,免費在線閱讀,更多相關內(nèi)容在行業(yè)資料-天天文庫。
1、ODPSSQL參考手冊ODPSSQL參考手冊修改記錄修改日期修改說明作者2012/9/8初始版本張云遠2012/10/09更新ALTERTABLE及CHAR_MATCHCOUNT的說明張云遠2012/11/19更新showtablesinproject張云遠ceil/percent_rank/regexp_extract自動統(tǒng)計的行為(inf,filter)Mapjoin支持不等值join及or1AliyunODPSSQL參考手冊目錄ODPSSQL參考手冊.........................................
2、...............................................................................11.簡要說明...........................................................................................................................42.數(shù)據(jù)存儲單元.....................................................
3、..............................................................43.數(shù)據(jù)類型...........................................................................................................................44.保留字.........................................................................
4、......................................................55.運算符...............................................................................................................................75.1.關系操作符..........................................................................
5、.................................75.2.算術操作符...........................................................................................................75.3.位運算操作符.......................................................................................................85.4.邏輯
6、操作符...........................................................................................................86.使用控制臺.......................................................................................................................97.DDL語法..........................
7、.................................................................................................97.1.創(chuàng)建表(CREATETABLE)..........................................................................................97.2.創(chuàng)建視圖(CREATEVIEW)..........................................
8、...........................................107.3.刪除表(DROPTABLE)........................................