Changes between Version 9 and Version 10 of chwhs


Ignore:
Timestamp:
Jun 12, 2008, 10:48:22 AM (16 years ago)
Author:
chwhs
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • chwhs

    v9 v10  
    6060
    6161
    62 
     62 * 2008/06/12
     63   * 根據Hypertable 在Google Code 上wiki 發佈的文件做測試
     64     * 標題為 HQLTutorial - A brief introduction to Hypertable Query Language (HQL):[http://code.google.com/p/hypertable/wiki/HQLTutorial]
     65   * 發現1：
     66     * 在INSERT & DELETE部份, 他教我們可以插入過去跟未來時間的資料,但是過去時間的資料卻不給插入。
     67       * hypertable> insert into Pages values ('2006-01-01 23:59:59', "www.hypertable.org", "refer-url", "www.zvents.com"); --> 此指令是不可以使用的
     68       * 會有這樣的錯誤訊息 Error: Problem sending updates (table=PAGES) - RANGE SERVER supplied timestamp is not strictly increasing
     69       * 經過查證：他說timestamp一般只預設允許系統自動分派,才不會造成混亂。可參考：[http://groups.google.com/group/hypertable-user/browse_thread/thread/da5f987760497811]
     70   * 發現2：
     71     * && TIMESTAMP >= '2008-06-10 09:12:37' && TIMESTAMP <= '2008-06-10 09:12:38' --> TIMESTAMP <= '時間' 的設定條件 並無效用 (答案未明@@)
     72       *
     73{{{
     74hypertable> select "refer-url" from Pages where ROW >= "www.zvents.com/events/buy_tickets/80283482" && ROW <= "www.zvents.com/events/buy_tickets/80310000" && TIMESTAMP >= '2008-06-10 09:12:37' && TIMESTAMP <= '2008-06-10 09:12:38' DISPLAY_TIMESTAMPS;
     752008-06-10 09:12:39.154415952   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     762008-06-10 09:12:39.154415949   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     772008-06-10 09:12:37.063994904   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     782008-06-10 09:12:37.063994907   www.zvents.com/events/buy_tickets/80308810      refer-url       www.zvents.com/las-vegas-nv/events/show/80308810-the-platters-coasters-and-the-legendary-lead-singers-of-the-temptations
     79}}}
     80       *
     81{{{
     82hypertable> select "refer-url" from Pages where ROW >= "www.zvents.com/events/buy_tickets/80283482" && ROW <= "www.zvents.com/events/buy_tickets/80310000" && TIMESTAMP >= '2008-06-10 09:12:38' DISPLAY_TIMESTAMPS;
     832008-06-10 09:12:39.154415952   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     842008-06-10 09:12:39.154415949   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     85}}}
     86       *
     87{{{
     88hypertable> select "refer-url" from Pages where ROW >= "www.zvents.com/events/buy_tickets/80283482" && ROW <= "www.zvents.com/events/buy_tickets/80310000" && TIMESTAMP <= '2008-06-10 09:12:38' DISPLAY_TIMESTAMPS;
     892008-06-10 09:12:39.154415952   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     902008-06-10 09:12:39.154415949   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     912008-06-10 09:12:37.063994904   www.zvents.com/events/buy_tickets/80283482      refer-url       www.zvents.com/san-francisco-ca/events/show/80283482-steve-martin
     922008-06-10 09:12:37.063994907   www.zvents.com/events/buy_tickets/80308810      refer-url       www.zvents.com/las-vegas-nv/events/show/80308810-the-platters-coasters-and-the-legendary-lead-singers-of-the-temptations
     93}}}