[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-10 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 @paulojblack Generally, we recommend to use [Official ASF releases](http://hivemall.incubator.apache.org/download.html), not one in the master branch. When you are using the master

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-10 Thread paulojblack
Github user paulojblack commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 That makes sense, I figured a change like that wasnt made blindly. Consider it a heads up on the docs then! ---

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-09 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 If you are using `v0.5.0`, then you need to use [one of v0.5.0](https://github.com/apache/incubator-hivemall/blob/v0.5.0/resources/ddl/define-all.hive). DDLs are pointing specified

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-09 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 @paulojblack You need to use up-to-date DDLs since we updated DDLs for `subarray` UDF in

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-09 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 @jeromebanks Add you to [the committer list](http://hivemall.incubator.apache.org/team-list.html) with

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-09 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 @paulojblack Thank you for comments. Will confirm it and fix master. ---

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-09 Thread paulojblack
Github user paulojblack commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 Just a heads up, I think some of the changes here that were pushed to master recently have broken set-up as instructed in the getting started docs. Specifically having

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-06 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 @maropu Deprecated SubarrayUDF to use ArraySliceUDF instead. FYI ---

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-05 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 ```sql create temporary function array_slice as 'hivemall.tools.array.ArraySliceUDF'; select array_slice( array("zero", "one", "two", "three", "four", "five",

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-05 Thread maropu
Github user maropu commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 @myui Spark already has these functions: https://github.com/apache/spark/blob/master/sql/core/src/main/scala/org/apache/spark/sql/functions.scala#L3118 ---

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-05 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 ```sql create temporary function conditional_emit as 'hivemall.tools.array.ConditionalEmitUDTF'; WITH input as ( select array(true, false, true) as conditions,

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-05 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 @maropu Could you check whether `to_json` and `from_json` works on Spark or not if possible? I'm not sure hcatalog is provided in Spark environment.

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-04-04 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 ```sql create temporary function moving_avg as 'hivemall.statistics.MovingAverageUDTF'; select moving_avg(x, 3) from (select explode(array(1,2,3,4,5,6,7)) as x) series;

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-03-27 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 ```sql select NAMED_STRUCT("Name", "John", "age", 31), to_json( NAMED_STRUCT("Name", "John", "age", 31) ), to_json( NAMED_STRUCT("Name", "John",

[GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions

2018-02-27 Thread myui
Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 Still WIP for [reviewing](https://docs.google.com/spreadsheets/d/1gtFNcTvPR9OZAsbobj2D9d37tOx4nAoSlib9CLdEDQg/edit#gid=0) functions to merge. ---