[MADLIB-1388] Deep Learning module does not work with tables in non-public schemas

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.17
• Component/s: Deep Learning
• Assignee: Orhan Kislal
• Reporter: Orhan Kislal
• Created: 15/Oct/19 23:59
• Updated: 06/Nov/19 19:09
• Resolved: 06/Nov/19 19:09

Description

I have tried both source table and model arch table in schemas to replicate the issue. It seems the quote indent is tripping up the validation code which causes the following error.

madlib=# SELECT madlib_keras_fit(                                                                                      's1.t2',                                                                                                           'keras_saved_out',                                                                                                 'model_arch',                                                                                                      1,                                                                                                                 $$ optimizer=SGD(lr=0.01, decay=1e-6, nesterov=True), loss='categorical_crossentropy', metrics=['accuracy']$$::text,                                                                                                                  $$ batch_size=2, epochs=1, verbose=0 $$::text,                                                                     3);
ERROR:  plpy.Error: madlib_keras_fit error: Input table '"s1.t2"' does not exist. (plpy_elog.c:121)
CONTEXT:  Traceback (most recent call last):
  PL/Python function "madlib_keras_fit", line 21, in <module>
    madlib_keras.fit(**globals())
  PL/Python function "madlib_keras_fit", line 42, in wrapper
  PL/Python function "madlib_keras_fit", line 99, in fit
  PL/Python function "madlib_keras_fit", line 370, in __init__
  PL/Python function "madlib_keras_fit", line 260, in __init__
  PL/Python function "madlib_keras_fit", line 268, in _validate_common_args
  PL/Python function "madlib_keras_fit", line 674, in input_tbl_valid
PL/Python function "madlib_keras_fit"