Travis CI
build****@travi*****
Wed May 18 01:07:15 JST 2016
Build Update for groonga/groonga
-------------------------------------
Build: #7668
Status: Errored
Duration: 32 minutes and 14 seconds
Commit: e19bfde (master)
Author: Kouhei Sutou
Message: Support window function
row_number() is the only available window function for now.
Here is an usage:
table_create Items TABLE_HASH_KEY ShortText
column_create Items price COLUMN_SCALAR UInt32
load --table Items
[
{"_key": "item1", "price": 666},
{"_key": "item2", "price": 999},
{"_key": "item3", "price": 777},
{"_key": "item4", "price": 111},
{"_key": "item5", "price": 333},
{"_key": "item6", "price": 222}
]
select Items \
--column[nth_row].stage initial \
--column[nth_row].value 'row_number()' \
--column[nth_row].type UInt32 \
--column[nth_row].window.sort_keys -price \
--output_columns '_key, price, nth_row'
#[
# [
# 0,
# 0.0,
# 0.0
# ],
# [
# [
# [
# 6
# ],
# [
# [
# "_key",
# "ShortText"
# ],
# [
# "price",
# "UInt32"
# ],
# [
# "nth_row",
# "UInt32"
# ]
# ],
# [
# "item1",
# 666,
# 3
# ],
# [
# "item2",
# 999,
# 1
# ],
# [
# "item3",
# 777,
# 2
# ],
# [
# "item4",
# 111,
# 6
# ],
# [
# "item5",
# 333,
# 4
# ],
# [
# "item6",
# 222,
# 5
# ]
# ]
# ]
#]
New APIs:
* GRN_WINDOW_FUNCTION_ERROR
* GRN_PROC_WINDOW_FUNCTION
* grn_obj_is_window_function_proc()
* grn_window_direction
* grn_window
* grn_window_next()
* grn_window_rewind()
* grn_window_set_direction()
* grn_window_get_table()
* grn_window_definition
* grn_window_function_func
* grn_window_function_create()
* grn_table_apply_window_function()
View the changeset: https://github.com/groonga/groonga/compare/b5570437f5bf...e19bfde7bcf9
View the full build log and details: https://travis-ci.org/groonga/groonga/builds/130865829
--
You can configure recipients for build notifications in your .travis.yml file. See https://docs.travis-ci.com/user/notifications
-------------- next part --------------
An HTML attachment was scrubbed...
Download