fmcquillan99 commented on pull request #518:
URL: https://github.com/apache/madlib/pull/518#issuecomment-707396018


   (11)
   ```
   SELECT madlib.madlib_keras_automl('cifar10_train_packed', 
                                     'automl_cifar10_output', 
                                     'model_arch_library', 
                                     'automl_cifar10_mst_table',
                                     ARRAY[2], 
                                     $${'loss': ['categorical_crossentropy'], 
                                        'optimizer_params_list': [ 
                                            {'optimizer': ['Adam'],'lr': 
[0.0001, 0.01, 'log']},
                                            {'optimizer': ['RMSprop'],'lr': 
[0.0001, 0.01, 'log'], 'decay': [1.0e-7, 1.0e-5, 'log']},
                                            {'optimizer': ['SGD'],'lr': 
[0.0001, 0.01, 'log'], 'momentum': [0.9, 0.99,'log']}],
                                        'metrics':['accuracy']}$$, 
                                     $${'batch_size': [128], 'epochs': [1]}$$,
                                     'hyperopt', 
                                     'num_configs=100, num_iterations=3, 
algorithm=tpe',
                                     NULL,                    -- random state
                                     NULL,                  -- object table
                                     FALSE,                 -- use GPUs
                                     'cifar10_val_packed', -- validation table
                                     1,                     -- metrics compute 
freq
                                     NULL,                  -- name
                                     NULL);                 -- descr
   ```
   produces
   ```
   select mst_key, metrics_elapsed_time from 
hopt_cifar10_output_info_c100n3tperun1 order by mst_key;
    mst_key |                 metrics_elapsed_time                 
   ---------+------------------------------------------------------
          1 | {627.882262945175,1264.80915999413,1896.74943590164}
          2 | {614.573877811432,1251.1022670269,1883.14707994461}
          3 | {638.407788038254,1286.73397421837,1939.58357810974}
          4 | {624.925609111786,1273.55782914162,1925.82674407959}
          5 | {650.984225034714,1307.78145503998,1962.8148560524}
          6 | {637.914520978928,1294.23532605171,1949.12843108177}
          7 | {651.188719987869,1301.32990193367,1948.88206887245}
          8 | {637.525157928467,1288.19901585579,1935.65923500061}
          9 | {651.277820110321,1301.09531402588,1947.13559818268}
         10 | {637.898158073425,1287.54387116432,1933.5972070694}
         11 | {650.482151985168,1309.5760037899,1961.18471598625}
         12 | {637.149097919464,1295.67461585999,1947.66235399246}
         13 | {651.543440818787,1299.3868060112,1948.78301692009}
         14 | {638.292811870575,1285.66767001152,1935.02927088737}
         15 | {650.077238082886,1305.37611913681,1962.8950419426}
         16 | {636.498329162598,1291.3173930645,1948.41972708702}
         17 | {649.946799993515,1303.33863401413,1949.58992981911}
         18 | {636.373380899429,1289.27607584,1936.36742186546}
         19 | {647.414880990982,1297.31931090355,1945.65248298645}
         20 | {634.09289598465,1284.170140028,1932.07456684113}
         21 | {684.188683986664,1330.76613283157,1980.06952404976}
         22 | {670.57110285759,1317.26948404312,1966.71574902534}
         23 | {651.919174909592,1304.4483089447,1949.68165898323}
         24 | {637.834177970886,1290.82985186577,1936.79075098038}
         25 | {655.077679872513,1298.5494530201,1945.88967299461}
         26 | {642.029677867889,1285.51564288139,1932.42474102974}
         27 | {647.519994020462,1291.86638307571,1940.63740706444}
         28 | {634.281761884689,1277.6536450386,1927.27670001984}
         29 | {649.227880954742,1295.78293895721,1939.8649418354}
         30 | {635.665500879288,1282.13676691055,1926.41391181946}
         31 | {646.891736984253,1292.39306688309,1939.45323801041}
         32 | {633.289309024811,1278.57114887238,1925.29498195648}
         33 | {645.044659852982,1294.90844988823,1934.83831381798}
         34 | {631.370570898056,1281.09457278252,1921.84612298012}
         35 | {641.974558115005,1287.15608096123,1933.71887016296}
         36 | {628.698891162872,1273.55222702026,1920.55405902863}
         37 | {645.359504938126,1286.81019496918,1936.24443602562}
         38 | {632.138350963593,1273.69606280327,1921.84107279778}
         39 | {645.965959072113,1291.83859109879,1934.28793001175}
         40 | {631.842108011246,1278.0611550808,1921.37190818787}
         41 | {644.744366168976,1284.78299307823,1926.56299805641}
         42 | {631.000986099243,1271.36041498184,1912.94822907448}
         43 | {646.629382133484,1289.81746912003,1938.30674505234}
         44 | {633.08934211731,1276.87801408768,1924.48914599419}
         45 | {645.794209003448,1289.52689504623,1928.10301995277}
         46 | {632.544068098068,1276.46976709366,1915.18053913116}
         47 | {648.967436075211,1296.18764710426,1942.72390508652}
         48 | {635.180493116379,1282.65127015114,1928.7596950531}
         49 | {642.685960054398,1281.86446094513,1924.27530503273}
         50 | {628.867849111557,1268.81643414497,1910.81892299652}
         51 | {642.25784611702,1285.31040906906,1931.93548893929}
         52 | {628.323985099792,1271.58122897148,1918.26403403282}
         53 | {641.810137033463,1285.25560903549,1929.13687109947}
         54 | {628.287924051285,1271.25157594681,1915.76375198364}
         55 | {645.721904993057,1285.12515211105,1928.89319014549}
         56 | {632.100169181824,1271.49339413643,1915.78533101082}
         57 | {639.617475986481,1275.61342597008,1915.39825177193}
         58 | {626.503052949905,1262.02722096443,1901.32048177719}
         59 | {635.73348903656,1280.25348901749,1919.08957004547}
         60 | {622.708857059479,1266.27361917496,1905.91475009918}
         61 | {640.503421068192,1279.74774312973,1920.75052404404}
         62 | {627.23721909523,1266.51659917831,1906.79211616516}
         63 | {642.081022977829,1277.49766278267,1916.42965888977}
         64 | {628.109483957291,1264.7400097847,1903.20749592781}
         65 | {640.490365028381,1283.00291013718,1924.50952506065}
         66 | {627.058392047882,1269.47951006889,1910.89861011505}
         67 | {636.89220905304,1277.09766602516,1910.96581101418}
         68 | {624.116094112396,1263.90056610107,1898.12311601639}
         69 | {635.469167947769,1269.55181598663,1904.01561403275}
         70 | {622.43970489502,1256.59510493279,1890.07668590546}
         71 | {636.119792938232,1276.15144109726,1913.03098011017}
         72 | {622.38174700737,1262.04434704781,1899.77307701111}
         73 | {635.743231058121,1276.63025021553,1917.14123606682}
         74 | {622.766848087311,1263.39644908905,1903.07419419289}
         75 | {630.598103046417,1267.86923599243,1899.72781896591}
         76 | {617.88782787323,1254.63754701614,1886.25667786598}
         77 | {632.587329149246,1270.71484613419,1902.50029301643}
         78 | {619.189999103546,1257.35159301758,1889.55543804169}
         79 | {631.962325811386,1268.57928681374,1901.31368494034}
         80 | {618.959751844406,1255.32190680504,1888.31697797775}
         81 | {634.275179862976,1261.66588997841,1895.5607509613}
         82 | {619.90931391716,1248.77173399925,1882.48632383347}
         83 | {633.14914894104,1265.85549592972,1897.17652893066}
         84 | {619.785959005356,1252.29544901848,1884.09737896919}
         85 | {627.898339033127,1261.44491815567,1893.74317097664}
         86 | {615.068039178848,1248.09124517441,1879.57727813721}
         87 | {633.1245470047,1268.63815689087,1904.82987594604}
         88 | {619.971349954605,1255.54224300385,1891.63547801971}
         89 | {634.308418035507,1267.44264101982,1903.04254603386}
         90 | {621.244497060776,1254.47942519188,1889.07282710075}
         91 | {638.813256025314,1286.2553050518,1923.13115119934}
         92 | {624.587430000305,1271.47850799561,1909.81140208244}
         93 | {635.323696136475,1271.31673598289,1910.10420203209}
         94 | {622.143538951874,1258.46868395805,1896.75948596001}
         95 | {636.06889295578,1269.57318091393,1905.99937295914}
         96 | {621.923580884933,1255.54979085922,1892.35493183136}
         97 | {635.867208957672,1275.91143798828,1907.85138106346}
         98 | {622.153614997864,1262.45370602608,1895.00853896141}
         99 | {632.058423995972,1264.59007382393,1902.03439188004}
        100 | {618.850169897079,1251.59025883675,1889.0108628273}
   (100 rows)
   ```
   These times should be cumulative, not relative to when the trial started.  
We want to be able to do a plot that looks like:
   
   
![image](https://user-images.githubusercontent.com/10538173/95799055-5846b500-0ca8-11eb-9f3a-b2dc35b416d0.png)
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to