This is an automated email from the ASF dual-hosted git repository. njayaram pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/madlib.git
commit 6f19d906300f59d592deb1aefb374548ed1fe4f5 Author: Domino Valdano <[email protected]> AuthorDate: Mon May 13 12:07:24 2019 -0700 DL: Update input table for fit dev check Co-authored-by: Jingyi Mei <[email protected]> --- .../modules/deep_learning/test/madlib_keras.sql_in | 22 ++++++++++++---------- 1 file changed, 12 insertions(+), 10 deletions(-) diff --git a/src/ports/postgres/modules/deep_learning/test/madlib_keras.sql_in b/src/ports/postgres/modules/deep_learning/test/madlib_keras.sql_in index 404c39c..a1968b0 100644 --- a/src/ports/postgres/modules/deep_learning/test/madlib_keras.sql_in +++ b/src/ports/postgres/modules/deep_learning/test/madlib_keras.sql_in @@ -43,20 +43,14 @@ copy cifar_10_sample_val from stdin delimiter '|'; DROP TABLE IF EXISTS cifar_10_sample_batched; CREATE TABLE cifar_10_sample_batched( - buffer_id smallint, + independent_var real[], dependent_var integer[], - independent_var real[]); + buffer_id smallint); copy cifar_10_sample_batched from stdin delimiter '|'; -0|{{0,1},{1,0}}|{{{{0.792157,0.8,0.780392},{0.792157,0.8,0.780392},{0.8,0.807843,0.788235},{0.807843,0.815686,0.796079},{0.815686,0.823529,0.803922},{0.819608,0.827451,0.807843},{0.823529,0.831373,0.811765},{0.831373,0.839216,0.823529},{0.835294,0.843137,0.831373},{0.843137,0.85098,0.839216},{0.847059,0.854902,0.843137},{0.847059,0.854902,0.843137},{0.843137,0.85098,0.839216},{0.847059,0.854902,0.843137},{0.847059,0.854902,0.843137},{0.847059,0.854902,0.839216},{0.85098,0.858824,0.839216 [...] +{{{{0.494118,0.462745,0.431373},{0.478431,0.45098,0.423529},{0.494118,0.466667,0.435294},{0.498039,0.466667,0.427451},{0.509804,0.478431,0.435294},{0.509804,0.478431,0.435294},{0.517647,0.486275,0.443137},{0.521569,0.490196,0.447059},{0.509804,0.478431,0.435294},{0.517647,0.486275,0.443137},{0.52549,0.494118,0.45098},{0.513726,0.482353,0.439216},{0.513726,0.482353,0.439216},{0.52549,0.494118,0.45098},{0.521569,0.490196,0.447059},{0.533333,0.501961,0.458824},{0.537255,0.505882,0.462745},{ [...] +{{{{0.792157,0.8,0.780392},{0.792157,0.8,0.780392},{0.8,0.807843,0.788235},{0.807843,0.815686,0.796079},{0.815686,0.823529,0.803922},{0.819608,0.827451,0.807843},{0.823529,0.831373,0.811765},{0.831373,0.839216,0.823529},{0.835294,0.843137,0.831373},{0.843137,0.85098,0.839216},{0.847059,0.854902,0.843137},{0.847059,0.854902,0.843137},{0.843137,0.85098,0.839216},{0.847059,0.854902,0.843137},{0.847059,0.854902,0.843137},{0.847059,0.854902,0.839216},{0.85098,0.858824,0.839216},{0.85098,0.858 [...] \. --- In order to test fit_merge, we need at least 2 rows in the batched table (1 on each segment). --- As part of supporting Postgres, an issue was reported JIRA MADLIB-1326. --- If we don't fix the bug, we should regenerate the batched table with this command --- (and paste it into the file). (If we do fix the bug, we can just uncomment this line, --- and remove the mocked output tables above.) --- SELECT minibatch_preprocessor_dl('cifar_10_sample','cifar_10_sample_batched','y','x', 1, 255); - DROP TABLE IF EXISTS cifar_10_sample_batched_summary; CREATE TABLE cifar_10_sample_batched_summary( source_table text, @@ -77,6 +71,14 @@ INSERT INTO cifar_10_sample_batched_summary values ( 1, 255.0); +--- NOTE: In order to test fit_merge, we need at least 2 rows in the batched table (1 on each segment). +--- ALSO NOTE: As part of supporting Postgres, an issue was reported JIRA MADLIB-1326. +--- Once this bug is fixed, we should uncomment these 2 lines, which was used to generate +--- the 4 tables above (cifar_10_sample{|_val}_batched{|_summary}). Only the original +---- cifar_10_sample table should be hard-coded, so we don't have to keep re-generating +---- all of these tables by hand every time something changes. +--- SELECT minibatch_preprocessor_dl('cifar_10_sample','cifar_10_sample_batched','y','x', 1, 255); + DROP TABLE IF EXISTS model_arch; SELECT load_keras_model('model_arch', $${
