Euclid mock production v1.9.3 - Revision history

Jcarrete at 14:03, 31 July 2020

2020-07-31T14:03:16Z

Jcarrete at 13:37, 31 July 2020

2020-07-31T13:37:14Z

Jcarrete at 11:38, 23 July 2020

2020-07-23T11:38:27Z

Jcarrete at 10:10, 23 July 2020

2020-07-23T10:10:01Z

Show changes

Jcarrete: Created page with "Catalog is created using the new platform through jupyter lab and Spark It is necessary to use kerberos certificates to run the jupyter lab with Spark There is a google doc..."

2020-07-21T16:11:15Z

Created page with "Catalog is created using the new platform through jupyter lab and Spark It is necessary to use kerberos certificates to run the jupyter lab with Spark There is a google doc..."

Show changes

@@ Line 13: / Line 13: @@
 The external table:
-     CREATE EXTERNAL TABLE `flagship_mock_1_9_3_p`(
+     CREATE EXTERNAL TABLE jcarrete.flagship_mock_1_9_3_p(
    `kind` bigint,
    `luminosity_r01` double,
@@ Line 686: / Line 686: @@
 And finally we add the proper header and store the FITS files in the webdavdoor using the corresponding notebook.
 It is tag in the git repository as tag: v1.9.3_FITS.

@@ Line 527: / Line 527: @@
+     {
-     "sql": "SELECT CAST(((halo_id * 10000) + galaxy_id) AS bigint) AS SOURCE_ID,  \nCAST(ra_gal AS float) AS RA,  \nCAST(dec_gal AS float) AS `DEC`,  \nCAST(ra_gal AS float) AS RA_MAG,  \nCAST(dec_gal AS float) AS DEC_MAG,  \nCAST(observed_redshift_gal AS float) AS Z_OBS,  \nCAST(abs_mag_r01_evolved AS float) AS REF_MAG_ABS,  \nCAST(-2.5*log10(sdss_r01) - 48.6 AS float) AS REF_MAG,  \nCAST(bulge_fraction AS float) AS BULGE_FRACTION,  \nCAST(bulge_r50 AS float) AS BULGE_R50,  \nCAST(disk_r50 AS float) AS DISK_R50,  \nCAST(bulge_nsersic AS float) AS BULGE_NSERSIC,  \nCAST(((1-bulge_fraction)*disk_inclination_angle + bulge_fraction*bulge_inclination_angle)*180/3.1415927 AS float) AS INCLINATION_ANGLE,  \nCAST(disk_angle AS float) AS DISK_ANGLE,  \nCAST( sed_cosmos AS float) AS SED_TEMPLATE,  \nCAST(ROUND(ext_curve_cosmos) AS smallint) AS EXT_LAW,  \nCAST(ebv_cosmos AS float) AS EBV,  \nCAST(logf_halpha_model3_ext AS float) AS HALPHA_LOGFLAM_EXT,  \nCAST(logf_hbeta_model3_ext AS float) AS HBETA_LOGFLAM_EXT,  \nCAST(logf_o2_model3_ext AS float) AS O2_LOGFLAM_EXT,  \nCAST(logf_o3_model3_ext AS float) AS O3_LOGFLAM_EXT,  \nCAST(logf_n2_model3_ext AS float) AS N2_LOGFLAM_EXT,  \nCAST(logf_s2_model3_ext AS float) AS S2_LOGFLAM_EXT,  \nCAST(mw_extinction AS float) AS AV,  \nCAST(euclid_vis_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_VIS,  \nCAST(euclid_nisp_y_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Y_NISP,  \nCAST(euclid_nisp_j_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_J_NISP,  \nCAST(euclid_nisp_h_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_H_NISP,  \nCAST(blanco_decam_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_DECAM,  \nCAST(blanco_decam_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_DECAM,  \nCAST(blanco_decam_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_DECAM,  \nCAST(blanco_decam_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_DECAM,  \nCAST(cfht_megacam_u_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_U_MEGACAM,  \nCAST(cfht_megacam_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_MEGACAM,  \nCAST(jst_jpcam_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_JPCAM,  \nCAST(pan_starrs_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_PANSTARRS,  \nCAST(pan_starrs_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_PANSTARRS,  \nCAST(subaru_hsc_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_HSC,  \nCAST(gaia_g_el_model3_odonnell_ext*1.e23  AS float)  AS TU_FNU_G_GAIA,  \nCAST(gaia_bp_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_BP_GAIA,  \nCAST(gaia_rp_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_RP_GAIA,  \nCAST(lsst_u_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_U_LSST,  \nCAST(lsst_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_LSST,  \nCAST(lsst_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_LSST,  \nCAST(lsst_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_LSST,  \nCAST(lsst_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_LSST,  \nCAST(lsst_y_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Y_LSST,  \nCAST(kids_u_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_U_KIDS,  \nCAST(kids_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_KIDS,  \nCAST(kids_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_KIDS,  \nCAST(kids_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_KIDS,  \nCAST(2mass_j_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_J_2MASS,  \nCAST(2mass_h_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_H_2MASS,  \nCAST(2mass_ks_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_KS_2MASS,  \nCAST( SHIFTRIGHT(hpix_29_nest, (29-5)*2)  AS bigint) AS hpix_5_nest  \nFROM cosmohub.flagship_mock_1_9_3_s  \nWHERE (logf_halpha_model3_ext > -16 OR -2.5*log10(euclid_nisp_h) - 48.6 < 26)  \nAND disk_axis_ratio > 0.10865  \nAND SHIFTRIGHT(hpix_29_nest, (29-5)*2) = 4522"
+     "sql": "SELECT CAST(((halo_id * 10000) + galaxy_id) AS bigint) AS SOURCE_ID,  \nCAST(ra_gal AS float) AS RA,  \nCAST(dec_gal AS float) AS `DEC`,  \nCAST(ra_mag_gal AS float) AS RA_MAG,  \nCAST(dec_mag_gal AS float) AS DEC_MAG,  \nCAST(observed_redshift_gal AS float) AS Z_OBS,  \nCAST(abs_mag_r01_evolved AS float) AS REF_MAG_ABS,  \nCAST(-2.5*log10(sdss_r01) - 48.6 AS float) AS REF_MAG,  \nCAST(bulge_fraction AS float) AS BULGE_FRACTION,  \nCAST(bulge_r50 AS float) AS BULGE_R50,  \nCAST(disk_r50 AS float) AS DISK_R50,  \nCAST(bulge_nsersic AS float) AS BULGE_NSERSIC,  \nCAST(((1-bulge_fraction)*disk_inclination_angle + bulge_fraction*bulge_inclination_angle)*180/3.1415927 AS float) AS INCLINATION_ANGLE,  \nCAST(disk_angle AS float) AS DISK_ANGLE,   \nCAST(kappa AS float) AS KAPPA,  \nCAST(gamma1 AS float) AS GAMMA1,  \nCAST(gamma2 AS float) AS GAMMA2,  \nCAST(sed_cosmos AS float) AS SED_TEMPLATE,  \nCAST(ROUND(ext_curve_cosmos) AS smallint) AS EXT_LAW,  \nCAST(ebv_cosmos AS float) AS EBV,  \nCAST(logf_halpha_model3_ext AS float) AS HALPHA_LOGFLAM_EXT,  \nCAST(logf_hbeta_model3_ext AS float) AS HBETA_LOGFLAM_EXT,  \nCAST(logf_o2_model3_ext AS float) AS O2_LOGFLAM_EXT,  \nCAST(logf_o3_model3_ext AS float) AS O3_LOGFLAM_EXT,  \nCAST(logf_n2_model3_ext AS float) AS N2_LOGFLAM_EXT,  \nCAST(logf_s2_model3_ext AS float) AS S2_LOGFLAM_EXT,  \nCAST(mw_extinction AS float) AS AV,  \nCAST(euclid_vis_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_VIS,  \nCAST(euclid_nisp_y_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Y_NISP,  \nCAST(euclid_nisp_j_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_J_NISP,  \nCAST(euclid_nisp_h_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_H_NISP,  \nCAST(blanco_decam_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_DECAM,  \nCAST(blanco_decam_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_DECAM,  \nCAST(blanco_decam_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_DECAM,  \nCAST(blanco_decam_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_DECAM,  \nCAST(cfht_megacam_u_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_U_MEGACAM,  \nCAST(cfht_megacam_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_MEGACAM,  \nCAST(jst_jpcam_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_JPCAM,  \nCAST(pan_starrs_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_PANSTARRS,  \nCAST(pan_starrs_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_PANSTARRS,  \nCAST(subaru_hsc_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_HSC,  \nCAST(gaia_g_el_model3_odonnell_ext*1.e23  AS float)  AS TU_FNU_G_GAIA,  \nCAST(gaia_bp_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_BP_GAIA,  \nCAST(gaia_rp_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_RP_GAIA,  \nCAST(lsst_u_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_U_LSST,  \nCAST(lsst_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_LSST,  \nCAST(lsst_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_LSST,  \nCAST(lsst_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_LSST,  \nCAST(lsst_z_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Z_LSST,  \nCAST(lsst_y_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_Y_LSST,  \nCAST(kids_u_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_U_KIDS,  \nCAST(kids_g_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_G_KIDS,  \nCAST(kids_r_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_R_KIDS,  \nCAST(kids_i_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_I_KIDS,  \nCAST(2mass_j_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_J_2MASS,  \nCAST(2mass_h_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_H_2MASS,  \nCAST(2mass_ks_el_model3_odonnell_ext*1.e23  AS float) AS TU_FNU_KS_2MASS,  \nCAST( SHIFTRIGHT(hpix_29_nest, (29-5)*2)  AS bigint) AS hpix_5_nest  \nFROM cosmohub.flagship_mock_1_9_3_s  \nWHERE (logf_halpha_model3_ext > -16 OR -2.5*log10(euclid_nisp_h) - 48.6 < 26)  \nAND disk_axis_ratio > 0.10865  \nAND SHIFTRIGHT(hpix_29_nest, (29-5)*2) = 4522"
+     }
@@ Line 548: / Line 548: @@
    `bulge_nsersic` float COMMENT 'from deserializer',
    `inclination_angle` float COMMENT 'from deserializer',
    `disk_angle` float COMMENT 'from deserializer',
    `sed_template` float COMMENT 'from deserializer',
    `ext_law` smallint COMMENT 'from deserializer',
@@ Line 621: / Line 624: @@
      CAST(ra_gal AS float) AS RA,
      CAST(dec_gal AS float) AS `DEC`,
-     CAST(ra_gal AS float) AS RA_MAG,
+     CAST(ra_mag_gal AS float) AS RA_MAG,
-     CAST(dec_gal AS float) AS DEC_MAG,
+     CAST(dec_mag_gal AS float) AS DEC_MAG,
      CAST(observed_redshift_gal AS float) AS Z_OBS,
      CAST(abs_mag_r01_evolved AS float) AS REF_MAG_ABS,
@@ Line 631: / Line 634: @@
      CAST(bulge_nsersic AS float) AS BULGE_NSERSIC,
      CAST(((1-bulge_fraction)*disk_inclination_angle + bulge_fraction*bulge_inclination_angle)*180/3.1415927 AS float) AS INCLINATION_ANGLE,
      CAST(disk_angle AS float) AS DISK_ANGLE,
      CAST( sed_cosmos AS float) AS SED_TEMPLATE,
      CAST(ROUND(ext_curve_cosmos) AS smallint) AS EXT_LAW,

← Older revision		Revision as of 11:38, 23 July 2020
Line 521:		Line 521:
	SELECT halo_id, galaxy_id, kind, random_index, ra_gal, dec_gal, ra_mag_gal, dec_mag_gal, kappa, gamma1, gamma2, l_gal, b_gal, mw_extinction, x_gal, y_gal, z_gal, r_gal, true_redshift_gal, observed_redshift_gal, hpix_29_nest, vx_gal, vy_gal, vz_gal, vrad_gal, delta_r, abs_mag_r01, luminosity_r01, abs_mag_r01_evolved, sdss_r01, abs_mag_uv_dereddened, gr_restframe, color_kind, sed_ke, gr_cosmos, sed_cosmos, is_within_cosmos, cosmos_distance, ext_curve_cosmos, ebv_cosmos, log_ml_r01, log_stellar_mass, metallicity, log_sfr, logf_halpha, logf_halpha_ext, halpha_scatter, loglum_halpha, loglum_halpha_ext, logf_dummy, z_dummy, logf_halpha_model1_ext, logf_halpha_model1, loglum_halpha_model1_ext, loglum_halpha_model1, logf_halpha_model3_ext, logf_halpha_model3, loglum_halpha_model3_ext, loglum_halpha_model3, logf_hbeta_model1_ext, logf_hbeta_model1, logf_o2_model1_ext, logf_o2_model1, logf_n2_model1_ext, logf_n2_model1, logf_o3_model1_ext, logf_o3_model1, logf_s2_model1_ext, logf_s2_model1, logf_hbeta_model3_ext, logf_hbeta_model3, logf_o2_model3_ext, logf_o2_model3, logf_n2_model3_ext, logf_n2_model3, logf_o3_model3_ext, logf_o3_model3, logf_s2_model3_ext, logf_s2_model3, 2mass_h, 2mass_j, 2mass_ks, blanco_decam_g, blanco_decam_i, blanco_decam_r, blanco_decam_z, cfht_megacam_r, cfht_megacam_u, euclid_nisp_h, euclid_nisp_j, euclid_nisp_y, euclid_vis, gaia_bp, gaia_g, gaia_rp, jst_jpcam_g, kids_g, kids_i, kids_r, kids_u, lsst_g, lsst_i, lsst_r, lsst_u, lsst_y, lsst_z, pan_starrs_i, pan_starrs_z, subaru_hsc_z, 2mass_h_odonnell_ext, 2mass_j_odonnell_ext, 2mass_ks_odonnell_ext, blanco_decam_g_odonnell_ext, blanco_decam_i_odonnell_ext, blanco_decam_r_odonnell_ext, blanco_decam_z_odonnell_ext, cfht_megacam_r_odonnell_ext, cfht_megacam_u_odonnell_ext, euclid_nisp_h_odonnell_ext, euclid_nisp_j_odonnell_ext, euclid_nisp_y_odonnell_ext, euclid_vis_odonnell_ext, gaia_bp_odonnell_ext, gaia_g_odonnell_ext, gaia_rp_odonnell_ext, jst_jpcam_g_odonnell_ext, kids_g_odonnell_ext, kids_i_odonnell_ext, kids_r_odonnell_ext, kids_u_odonnell_ext, lsst_g_odonnell_ext, lsst_i_odonnell_ext, lsst_r_odonnell_ext, lsst_u_odonnell_ext, lsst_y_odonnell_ext, lsst_z_odonnell_ext, pan_starrs_i_odonnell_ext, pan_starrs_z_odonnell_ext, sdss_r01_odonnell_ext, subaru_hsc_z_odonnell_ext, 2mass_h_el_model1_odonnell_ext, 2mass_h_el_model3_odonnell_ext, 2mass_j_el_model1_odonnell_ext, 2mass_j_el_model3_odonnell_ext, 2mass_ks_el_model1_odonnell_ext, 2mass_ks_el_model3_odonnell_ext, blanco_decam_g_el_model1_odonnell_ext, blanco_decam_g_el_model3_odonnell_ext, blanco_decam_i_el_model1_odonnell_ext, blanco_decam_i_el_model3_odonnell_ext, blanco_decam_r_el_model1_odonnell_ext, blanco_decam_r_el_model3_odonnell_ext, blanco_decam_z_el_model1_odonnell_ext, blanco_decam_z_el_model3_odonnell_ext, cfht_megacam_r_el_model1_odonnell_ext, cfht_megacam_r_el_model3_odonnell_ext, cfht_megacam_u_el_model1_odonnell_ext, cfht_megacam_u_el_model3_odonnell_ext, euclid_nisp_h_el_model1_odonnell_ext, euclid_nisp_h_el_model3_odonnell_ext, euclid_nisp_j_el_model1_odonnell_ext, euclid_nisp_j_el_model3_odonnell_ext, euclid_nisp_y_el_model1_odonnell_ext, euclid_nisp_y_el_model3_odonnell_ext, euclid_vis_el_model1_odonnell_ext, euclid_vis_el_model3_odonnell_ext, gaia_bp_el_model1_odonnell_ext, gaia_bp_el_model3_odonnell_ext, gaia_g_el_model1_odonnell_ext, gaia_g_el_model3_odonnell_ext, gaia_rp_el_model1_odonnell_ext, gaia_rp_el_model3_odonnell_ext, jst_jpcam_g_el_model1_odonnell_ext, jst_jpcam_g_el_model3_odonnell_ext, kids_g_el_model1_odonnell_ext, kids_g_el_model3_odonnell_ext, kids_i_el_model1_odonnell_ext, kids_i_el_model3_odonnell_ext, kids_r_el_model1_odonnell_ext, kids_r_el_model3_odonnell_ext, kids_u_el_model1_odonnell_ext, kids_u_el_model3_odonnell_ext, lsst_g_el_model1_odonnell_ext, lsst_g_el_model3_odonnell_ext, lsst_i_el_model1_odonnell_ext, lsst_i_el_model3_odonnell_ext, lsst_r_el_model1_odonnell_ext, lsst_r_el_model3_odonnell_ext, lsst_u_el_model1_odonnell_ext, lsst_u_el_model3_odonnell_ext, lsst_y_el_model1_odonnell_ext, lsst_y_el_model3_odonnell_ext, lsst_z_el_model1_odonnell_ext, lsst_z_el_model3_odonnell_ext, pan_starrs_i_el_model1_odonnell_ext, pan_starrs_i_el_model3_odonnell_ext, pan_starrs_z_el_model1_odonnell_ext, pan_starrs_z_el_model3_odonnell_ext, sdss_r01_el_model1_odonnell_ext, sdss_r01_el_model3_odonnell_ext, subaru_hsc_z_el_model1_odonnell_ext, subaru_hsc_z_el_model3_odonnell_ext, dominant_shape, bulge_angle, disk_angle, median_major_axis, scale_length, bulge_fraction, disk_scalelength, disk_nsersic, disk_r50, bulge_r50, bulge_nsersic, disk_ellipticity, bulge_ellipticity, disk_axis_ratio, bulge_axis_ratio, disk_inclination_angle, bulge_inclination_angle, halo_x, halo_y, halo_z, halo_vx, halo_vy, halo_vz, halo_r, true_redshift_halo, halo_lm, halo_n_sats, n_gals, luminosity_r01_evolved, hpix_13_nest, step FROM jcarrete.flagship_mock_1_9_3_p;		SELECT halo_id, galaxy_id, kind, random_index, ra_gal, dec_gal, ra_mag_gal, dec_mag_gal, kappa, gamma1, gamma2, l_gal, b_gal, mw_extinction, x_gal, y_gal, z_gal, r_gal, true_redshift_gal, observed_redshift_gal, hpix_29_nest, vx_gal, vy_gal, vz_gal, vrad_gal, delta_r, abs_mag_r01, luminosity_r01, abs_mag_r01_evolved, sdss_r01, abs_mag_uv_dereddened, gr_restframe, color_kind, sed_ke, gr_cosmos, sed_cosmos, is_within_cosmos, cosmos_distance, ext_curve_cosmos, ebv_cosmos, log_ml_r01, log_stellar_mass, metallicity, log_sfr, logf_halpha, logf_halpha_ext, halpha_scatter, loglum_halpha, loglum_halpha_ext, logf_dummy, z_dummy, logf_halpha_model1_ext, logf_halpha_model1, loglum_halpha_model1_ext, loglum_halpha_model1, logf_halpha_model3_ext, logf_halpha_model3, loglum_halpha_model3_ext, loglum_halpha_model3, logf_hbeta_model1_ext, logf_hbeta_model1, logf_o2_model1_ext, logf_o2_model1, logf_n2_model1_ext, logf_n2_model1, logf_o3_model1_ext, logf_o3_model1, logf_s2_model1_ext, logf_s2_model1, logf_hbeta_model3_ext, logf_hbeta_model3, logf_o2_model3_ext, logf_o2_model3, logf_n2_model3_ext, logf_n2_model3, logf_o3_model3_ext, logf_o3_model3, logf_s2_model3_ext, logf_s2_model3, 2mass_h, 2mass_j, 2mass_ks, blanco_decam_g, blanco_decam_i, blanco_decam_r, blanco_decam_z, cfht_megacam_r, cfht_megacam_u, euclid_nisp_h, euclid_nisp_j, euclid_nisp_y, euclid_vis, gaia_bp, gaia_g, gaia_rp, jst_jpcam_g, kids_g, kids_i, kids_r, kids_u, lsst_g, lsst_i, lsst_r, lsst_u, lsst_y, lsst_z, pan_starrs_i, pan_starrs_z, subaru_hsc_z, 2mass_h_odonnell_ext, 2mass_j_odonnell_ext, 2mass_ks_odonnell_ext, blanco_decam_g_odonnell_ext, blanco_decam_i_odonnell_ext, blanco_decam_r_odonnell_ext, blanco_decam_z_odonnell_ext, cfht_megacam_r_odonnell_ext, cfht_megacam_u_odonnell_ext, euclid_nisp_h_odonnell_ext, euclid_nisp_j_odonnell_ext, euclid_nisp_y_odonnell_ext, euclid_vis_odonnell_ext, gaia_bp_odonnell_ext, gaia_g_odonnell_ext, gaia_rp_odonnell_ext, jst_jpcam_g_odonnell_ext, kids_g_odonnell_ext, kids_i_odonnell_ext, kids_r_odonnell_ext, kids_u_odonnell_ext, lsst_g_odonnell_ext, lsst_i_odonnell_ext, lsst_r_odonnell_ext, lsst_u_odonnell_ext, lsst_y_odonnell_ext, lsst_z_odonnell_ext, pan_starrs_i_odonnell_ext, pan_starrs_z_odonnell_ext, sdss_r01_odonnell_ext, subaru_hsc_z_odonnell_ext, 2mass_h_el_model1_odonnell_ext, 2mass_h_el_model3_odonnell_ext, 2mass_j_el_model1_odonnell_ext, 2mass_j_el_model3_odonnell_ext, 2mass_ks_el_model1_odonnell_ext, 2mass_ks_el_model3_odonnell_ext, blanco_decam_g_el_model1_odonnell_ext, blanco_decam_g_el_model3_odonnell_ext, blanco_decam_i_el_model1_odonnell_ext, blanco_decam_i_el_model3_odonnell_ext, blanco_decam_r_el_model1_odonnell_ext, blanco_decam_r_el_model3_odonnell_ext, blanco_decam_z_el_model1_odonnell_ext, blanco_decam_z_el_model3_odonnell_ext, cfht_megacam_r_el_model1_odonnell_ext, cfht_megacam_r_el_model3_odonnell_ext, cfht_megacam_u_el_model1_odonnell_ext, cfht_megacam_u_el_model3_odonnell_ext, euclid_nisp_h_el_model1_odonnell_ext, euclid_nisp_h_el_model3_odonnell_ext, euclid_nisp_j_el_model1_odonnell_ext, euclid_nisp_j_el_model3_odonnell_ext, euclid_nisp_y_el_model1_odonnell_ext, euclid_nisp_y_el_model3_odonnell_ext, euclid_vis_el_model1_odonnell_ext, euclid_vis_el_model3_odonnell_ext, gaia_bp_el_model1_odonnell_ext, gaia_bp_el_model3_odonnell_ext, gaia_g_el_model1_odonnell_ext, gaia_g_el_model3_odonnell_ext, gaia_rp_el_model1_odonnell_ext, gaia_rp_el_model3_odonnell_ext, jst_jpcam_g_el_model1_odonnell_ext, jst_jpcam_g_el_model3_odonnell_ext, kids_g_el_model1_odonnell_ext, kids_g_el_model3_odonnell_ext, kids_i_el_model1_odonnell_ext, kids_i_el_model3_odonnell_ext, kids_r_el_model1_odonnell_ext, kids_r_el_model3_odonnell_ext, kids_u_el_model1_odonnell_ext, kids_u_el_model3_odonnell_ext, lsst_g_el_model1_odonnell_ext, lsst_g_el_model3_odonnell_ext, lsst_i_el_model1_odonnell_ext, lsst_i_el_model3_odonnell_ext, lsst_r_el_model1_odonnell_ext, lsst_r_el_model3_odonnell_ext, lsst_u_el_model1_odonnell_ext, lsst_u_el_model3_odonnell_ext, lsst_y_el_model1_odonnell_ext, lsst_y_el_model3_odonnell_ext, lsst_z_el_model1_odonnell_ext, lsst_z_el_model3_odonnell_ext, pan_starrs_i_el_model1_odonnell_ext, pan_starrs_i_el_model3_odonnell_ext, pan_starrs_z_el_model1_odonnell_ext, pan_starrs_z_el_model3_odonnell_ext, sdss_r01_el_model1_odonnell_ext, sdss_r01_el_model3_odonnell_ext, subaru_hsc_z_el_model1_odonnell_ext, subaru_hsc_z_el_model3_odonnell_ext, dominant_shape, bulge_angle, disk_angle, median_major_axis, scale_length, bulge_fraction, disk_scalelength, disk_nsersic, disk_r50, bulge_r50, bulge_nsersic, disk_ellipticity, bulge_ellipticity, disk_axis_ratio, bulge_axis_ratio, disk_inclination_angle, bulge_inclination_angle, halo_x, halo_y, halo_z, halo_vx, halo_vy, halo_vz, halo_r, true_redshift_halo, halo_lm, halo_n_sats, n_gals, luminosity_r01_evolved, hpix_13_nest, step FROM jcarrete.flagship_mock_1_9_3_p;

−
−	~~ANALYZE TABLE cosmohub.flagship_mock_1_9_3_s COMPUTE STATISTICS;~~

	ANALYZE TABLE cosmohub.flagship_mock_1_9_3_s COMPUTE STATISTICS FOR COLUMNS;		ANALYZE TABLE cosmohub.flagship_mock_1_9_3_s COMPUTE STATISTICS FOR COLUMNS;