Flagship-PAU v03
Jump to navigation
Jump to search
Creating a mock with PAU filters using the Flagship as input.
In this particular version we include CFHTLenS filters agreed between M.Eriksen and Durham people (GALFORM).
We still use the notebook:
/nfs/pic.es/user/j/jcarrete/python_notebooks/Flasghip-PAU_mock.ipynb
We select an area of ~ 4x4:
galaxy_sql = """ SELECT halo_id, galaxy_id, ra_gal, dec_gal, sed_cosmos, ext_curve_cosmos, ebv_cosmos, true_redshift_gal, observed_redshift_gal, abs_mag_r01_evolved, logf_halpha_model3_ext as logf_halpha_ext, logf_hbeta_model3_ext as logf_hbeta_ext, logf_o2_model3_ext as logf_o2_ext, logf_n2_model3_ext as logf_n2_ext, logf_o3_model3_ext as logf_o3_ext, logf_s2_model3_ext as logf_s2_ext FROM cosmohub.flagship_1_8_4_s WHERE -2.5 * log10(blanco_decam_i) -48.6 < 23. AND ra_gal BETWEEN 1. and 5. AND dec_gal BETWEEN 1. and 5. """
The catalog is created in the following hdfs path:
/hdfs/user/jcarrete/data/euclid/flagship_paus_20200527
[jcarrete@data flagship_paus_20200527]$ /software/astro/scripts/create_table_from_parquet.sh -p /hdfs/user/jcarrete/data/euclid/flagship_paus_20200527/0.pq -t jcarrete.pau_flagship_1_8_4_v0_3_pq -e
CREATE EXTERNAL TABLE jcarrete.pau_flagship_1_8_4_v0_3_pq (
`ra_gal` DOUBLE, `dec_gal` DOUBLE, `sed_cosmos` DOUBLE, `ext_curve_cosmos` BIGINT, `ebv_cosmos` DOUBLE, `true_redshift_gal` DOUBLE, `observed_redshift_gal` DOUBLE, `abs_mag_r01_evolved` DOUBLE, `logf_halpha_ext` DOUBLE, `logf_hbeta_ext` DOUBLE, `logf_o2_ext` DOUBLE, `logf_n2_ext` DOUBLE, `logf_o3_ext` DOUBLE, `logf_s2_ext` DOUBLE, `flux_nl_t_blanco_decam_g` DOUBLE, `flux_nl_el_t_blanco_decam_g` DOUBLE, `flux_err_sigma_blanco_decam_g` DOUBLE, `flux_err_realization_blanco_decam_g` DOUBLE, `flux_t_blanco_decam_g` DOUBLE, `flux_el_t_blanco_decam_g` DOUBLE, `flux_nl_t_blanco_decam_i` DOUBLE, `flux_nl_el_t_blanco_decam_i` DOUBLE, `flux_err_sigma_blanco_decam_i` DOUBLE, `flux_err_realization_blanco_decam_i` DOUBLE, `flux_t_blanco_decam_i` DOUBLE, `flux_el_t_blanco_decam_i` DOUBLE, `flux_nl_t_blanco_decam_r` DOUBLE, `flux_nl_el_t_blanco_decam_r` DOUBLE, `flux_err_sigma_blanco_decam_r` DOUBLE, `flux_err_realization_blanco_decam_r` DOUBLE, `flux_t_blanco_decam_r` DOUBLE, `flux_el_t_blanco_decam_r` DOUBLE, `flux_nl_t_blanco_decam_z` DOUBLE, `flux_nl_el_t_blanco_decam_z` DOUBLE, `flux_err_sigma_blanco_decam_z` DOUBLE, `flux_err_realization_blanco_decam_z` DOUBLE, `flux_t_blanco_decam_z` DOUBLE, `flux_el_t_blanco_decam_z` DOUBLE, `flux_nl_t_cfht_megacam_g_1` DOUBLE, `flux_nl_el_t_cfht_megacam_g_1` DOUBLE, `flux_err_sigma_cfht_megacam_g_1` DOUBLE, `flux_err_realization_cfht_megacam_g_1` DOUBLE, `flux_t_cfht_megacam_g_1` DOUBLE, `flux_el_t_cfht_megacam_g_1` DOUBLE, `flux_nl_t_cfht_megacam_i_1` DOUBLE, `flux_nl_el_t_cfht_megacam_i_1` DOUBLE, `flux_err_sigma_cfht_megacam_i_1` DOUBLE, `flux_err_realization_cfht_megacam_i_1` DOUBLE, `flux_t_cfht_megacam_i_1` DOUBLE, `flux_el_t_cfht_megacam_i_1` DOUBLE, `flux_nl_t_cfht_megacam_r_1` DOUBLE, `flux_nl_el_t_cfht_megacam_r_1` DOUBLE, `flux_err_sigma_cfht_megacam_r_1` DOUBLE, `flux_err_realization_cfht_megacam_r_1` DOUBLE, `flux_t_cfht_megacam_r_1` DOUBLE, `flux_el_t_cfht_megacam_r_1` DOUBLE, `flux_nl_t_cfht_megacam_u_1` DOUBLE, `flux_nl_el_t_cfht_megacam_u_1` DOUBLE, `flux_err_sigma_cfht_megacam_u_1` DOUBLE, `flux_err_realization_cfht_megacam_u_1` DOUBLE, `flux_t_cfht_megacam_u_1` DOUBLE, `flux_el_t_cfht_megacam_u_1` DOUBLE, `flux_nl_t_cfht_megacam_z_1` DOUBLE, `flux_nl_el_t_cfht_megacam_z_1` DOUBLE, `flux_err_sigma_cfht_megacam_z_1` DOUBLE, `flux_err_realization_cfht_megacam_z_1` DOUBLE, `flux_t_cfht_megacam_z_1` DOUBLE, `flux_el_t_cfht_megacam_z_1` DOUBLE, `flux_nl_t_cfht_u` DOUBLE, `flux_nl_el_t_cfht_u` DOUBLE, `flux_err_sigma_cfht_u` DOUBLE, `flux_err_realization_cfht_u` DOUBLE, `flux_t_cfht_u` DOUBLE, `flux_el_t_cfht_u` DOUBLE, `flux_nl_t_euclid_nisp_h` DOUBLE, `flux_nl_el_t_euclid_nisp_h` DOUBLE, `flux_err_sigma_euclid_nisp_h` DOUBLE, `flux_err_realization_euclid_nisp_h` DOUBLE, `flux_t_euclid_nisp_h` DOUBLE, `flux_el_t_euclid_nisp_h` DOUBLE, `flux_nl_t_euclid_nisp_j` DOUBLE, `flux_nl_el_t_euclid_nisp_j` DOUBLE, `flux_err_sigma_euclid_nisp_j` DOUBLE, `flux_err_realization_euclid_nisp_j` DOUBLE, `flux_t_euclid_nisp_j` DOUBLE, `flux_el_t_euclid_nisp_j` DOUBLE, `flux_nl_t_euclid_nisp_y` DOUBLE, `flux_nl_el_t_euclid_nisp_y` DOUBLE, `flux_err_sigma_euclid_nisp_y` DOUBLE, `flux_err_realization_euclid_nisp_y` DOUBLE, `flux_t_euclid_nisp_y` DOUBLE, `flux_el_t_euclid_nisp_y` DOUBLE, `flux_nl_t_euclid_vis` DOUBLE, `flux_nl_el_t_euclid_vis` DOUBLE, `flux_err_sigma_euclid_vis` DOUBLE, `flux_err_realization_euclid_vis` DOUBLE, `flux_t_euclid_vis` DOUBLE, `flux_el_t_euclid_vis` DOUBLE, `flux_nl_t_galex_nuv` DOUBLE, `flux_nl_el_t_galex_nuv` DOUBLE, `flux_err_sigma_galex_nuv` DOUBLE, `flux_err_realization_galex_nuv` DOUBLE, `flux_t_galex_nuv` DOUBLE, `flux_el_t_galex_nuv` DOUBLE, `flux_nl_t_pau_g` DOUBLE, `flux_nl_el_t_pau_g` DOUBLE, `flux_err_sigma_pau_g` DOUBLE, `flux_err_realization_pau_g` DOUBLE, `flux_t_pau_g` DOUBLE, `flux_el_t_pau_g` DOUBLE, `flux_nl_t_pau_i` DOUBLE, `flux_nl_el_t_pau_i` DOUBLE, `flux_err_sigma_pau_i` DOUBLE, `flux_err_realization_pau_i` DOUBLE, `flux_t_pau_i` DOUBLE, `flux_el_t_pau_i` DOUBLE, `flux_nl_t_pau_nb455` DOUBLE, `flux_nl_el_t_pau_nb455` DOUBLE, `flux_err_sigma_pau_nb455` DOUBLE, `flux_err_realization_pau_nb455` DOUBLE, `flux_t_pau_nb455` DOUBLE, `flux_el_t_pau_nb455` DOUBLE, `flux_nl_t_pau_nb465` DOUBLE, `flux_nl_el_t_pau_nb465` DOUBLE, `flux_err_sigma_pau_nb465` DOUBLE, `flux_err_realization_pau_nb465` DOUBLE, `flux_t_pau_nb465` DOUBLE, `flux_el_t_pau_nb465` DOUBLE, `flux_nl_t_pau_nb475` DOUBLE, `flux_nl_el_t_pau_nb475` DOUBLE, `flux_err_sigma_pau_nb475` DOUBLE, `flux_err_realization_pau_nb475` DOUBLE, `flux_t_pau_nb475` DOUBLE, `flux_el_t_pau_nb475` DOUBLE, `flux_nl_t_pau_nb485` DOUBLE, `flux_nl_el_t_pau_nb485` DOUBLE, `flux_err_sigma_pau_nb485` DOUBLE, `flux_err_realization_pau_nb485` DOUBLE, `flux_t_pau_nb485` DOUBLE, `flux_el_t_pau_nb485` DOUBLE, `flux_nl_t_pau_nb495` DOUBLE, `flux_nl_el_t_pau_nb495` DOUBLE, `flux_err_sigma_pau_nb495` DOUBLE, `flux_err_realization_pau_nb495` DOUBLE, `flux_t_pau_nb495` DOUBLE, `flux_el_t_pau_nb495` DOUBLE, `flux_nl_t_pau_nb505` DOUBLE, `flux_nl_el_t_pau_nb505` DOUBLE, `flux_err_sigma_pau_nb505` DOUBLE, `flux_err_realization_pau_nb505` DOUBLE, `flux_t_pau_nb505` DOUBLE, `flux_el_t_pau_nb505` DOUBLE, `flux_nl_t_pau_nb515` DOUBLE, `flux_nl_el_t_pau_nb515` DOUBLE, `flux_err_sigma_pau_nb515` DOUBLE, `flux_err_realization_pau_nb515` DOUBLE, `flux_t_pau_nb515` DOUBLE, `flux_el_t_pau_nb515` DOUBLE, `flux_nl_t_pau_nb525` DOUBLE, `flux_nl_el_t_pau_nb525` DOUBLE, `flux_err_sigma_pau_nb525` DOUBLE, `flux_err_realization_pau_nb525` DOUBLE, `flux_t_pau_nb525` DOUBLE, `flux_el_t_pau_nb525` DOUBLE, `flux_nl_t_pau_nb535` DOUBLE, `flux_nl_el_t_pau_nb535` DOUBLE, `flux_err_sigma_pau_nb535` DOUBLE, `flux_err_realization_pau_nb535` DOUBLE, `flux_t_pau_nb535` DOUBLE, `flux_el_t_pau_nb535` DOUBLE, `flux_nl_t_pau_nb545` DOUBLE, `flux_nl_el_t_pau_nb545` DOUBLE, `flux_err_sigma_pau_nb545` DOUBLE, `flux_err_realization_pau_nb545` DOUBLE, `flux_t_pau_nb545` DOUBLE, `flux_el_t_pau_nb545` DOUBLE, `flux_nl_t_pau_nb555` DOUBLE, `flux_nl_el_t_pau_nb555` DOUBLE, `flux_err_sigma_pau_nb555` DOUBLE, `flux_err_realization_pau_nb555` DOUBLE, `flux_t_pau_nb555` DOUBLE, `flux_el_t_pau_nb555` DOUBLE, `flux_nl_t_pau_nb565` DOUBLE, `flux_nl_el_t_pau_nb565` DOUBLE, `flux_err_sigma_pau_nb565` DOUBLE, `flux_err_realization_pau_nb565` DOUBLE, `flux_t_pau_nb565` DOUBLE, `flux_el_t_pau_nb565` DOUBLE, `flux_nl_t_pau_nb575` DOUBLE, `flux_nl_el_t_pau_nb575` DOUBLE, `flux_err_sigma_pau_nb575` DOUBLE, `flux_err_realization_pau_nb575` DOUBLE, `flux_t_pau_nb575` DOUBLE, `flux_el_t_pau_nb575` DOUBLE, `flux_nl_t_pau_nb585` DOUBLE, `flux_nl_el_t_pau_nb585` DOUBLE, `flux_err_sigma_pau_nb585` DOUBLE, `flux_err_realization_pau_nb585` DOUBLE, `flux_t_pau_nb585` DOUBLE, `flux_el_t_pau_nb585` DOUBLE, `flux_nl_t_pau_nb595` DOUBLE, `flux_nl_el_t_pau_nb595` DOUBLE, `flux_err_sigma_pau_nb595` DOUBLE, `flux_err_realization_pau_nb595` DOUBLE, `flux_t_pau_nb595` DOUBLE, `flux_el_t_pau_nb595` DOUBLE, `flux_nl_t_pau_nb605` DOUBLE, `flux_nl_el_t_pau_nb605` DOUBLE, `flux_err_sigma_pau_nb605` DOUBLE, `flux_err_realization_pau_nb605` DOUBLE, `flux_t_pau_nb605` DOUBLE, `flux_el_t_pau_nb605` DOUBLE, `flux_nl_t_pau_nb615` DOUBLE, `flux_nl_el_t_pau_nb615` DOUBLE, `flux_err_sigma_pau_nb615` DOUBLE, `flux_err_realization_pau_nb615` DOUBLE, `flux_t_pau_nb615` DOUBLE, `flux_el_t_pau_nb615` DOUBLE, `flux_nl_t_pau_nb625` DOUBLE, `flux_nl_el_t_pau_nb625` DOUBLE, `flux_err_sigma_pau_nb625` DOUBLE, `flux_err_realization_pau_nb625` DOUBLE, `flux_t_pau_nb625` DOUBLE, `flux_el_t_pau_nb625` DOUBLE, `flux_nl_t_pau_nb635` DOUBLE, `flux_nl_el_t_pau_nb635` DOUBLE, `flux_err_sigma_pau_nb635` DOUBLE, `flux_err_realization_pau_nb635` DOUBLE, `flux_t_pau_nb635` DOUBLE, `flux_el_t_pau_nb635` DOUBLE, `flux_nl_t_pau_nb645` DOUBLE, `flux_nl_el_t_pau_nb645` DOUBLE, `flux_err_sigma_pau_nb645` DOUBLE, `flux_err_realization_pau_nb645` DOUBLE, `flux_t_pau_nb645` DOUBLE, `flux_el_t_pau_nb645` DOUBLE, `flux_nl_t_pau_nb655` DOUBLE, `flux_nl_el_t_pau_nb655` DOUBLE, `flux_err_sigma_pau_nb655` DOUBLE, `flux_err_realization_pau_nb655` DOUBLE, `flux_t_pau_nb655` DOUBLE, `flux_el_t_pau_nb655` DOUBLE, `flux_nl_t_pau_nb665` DOUBLE, `flux_nl_el_t_pau_nb665` DOUBLE, `flux_err_sigma_pau_nb665` DOUBLE, `flux_err_realization_pau_nb665` DOUBLE, `flux_t_pau_nb665` DOUBLE, `flux_el_t_pau_nb665` DOUBLE, `flux_nl_t_pau_nb675` DOUBLE, `flux_nl_el_t_pau_nb675` DOUBLE, `flux_err_sigma_pau_nb675` DOUBLE, `flux_err_realization_pau_nb675` DOUBLE, `flux_t_pau_nb675` DOUBLE, `flux_el_t_pau_nb675` DOUBLE, `flux_nl_t_pau_nb685` DOUBLE, `flux_nl_el_t_pau_nb685` DOUBLE, `flux_err_sigma_pau_nb685` DOUBLE, `flux_err_realization_pau_nb685` DOUBLE, `flux_t_pau_nb685` DOUBLE, `flux_el_t_pau_nb685` DOUBLE, `flux_nl_t_pau_nb695` DOUBLE, `flux_nl_el_t_pau_nb695` DOUBLE, `flux_err_sigma_pau_nb695` DOUBLE, `flux_err_realization_pau_nb695` DOUBLE, `flux_t_pau_nb695` DOUBLE, `flux_el_t_pau_nb695` DOUBLE, `flux_nl_t_pau_nb705` DOUBLE, `flux_nl_el_t_pau_nb705` DOUBLE, `flux_err_sigma_pau_nb705` DOUBLE, `flux_err_realization_pau_nb705` DOUBLE, `flux_t_pau_nb705` DOUBLE, `flux_el_t_pau_nb705` DOUBLE, `flux_nl_t_pau_nb715` DOUBLE, `flux_nl_el_t_pau_nb715` DOUBLE, `flux_err_sigma_pau_nb715` DOUBLE, `flux_err_realization_pau_nb715` DOUBLE, `flux_t_pau_nb715` DOUBLE, `flux_el_t_pau_nb715` DOUBLE, `flux_nl_t_pau_nb725` DOUBLE, `flux_nl_el_t_pau_nb725` DOUBLE, `flux_err_sigma_pau_nb725` DOUBLE, `flux_err_realization_pau_nb725` DOUBLE, `flux_t_pau_nb725` DOUBLE, `flux_el_t_pau_nb725` DOUBLE, `flux_nl_t_pau_nb735` DOUBLE, `flux_nl_el_t_pau_nb735` DOUBLE, `flux_err_sigma_pau_nb735` DOUBLE, `flux_err_realization_pau_nb735` DOUBLE, `flux_t_pau_nb735` DOUBLE, `flux_el_t_pau_nb735` DOUBLE, `flux_nl_t_pau_nb745` DOUBLE, `flux_nl_el_t_pau_nb745` DOUBLE, `flux_err_sigma_pau_nb745` DOUBLE, `flux_err_realization_pau_nb745` DOUBLE, `flux_t_pau_nb745` DOUBLE, `flux_el_t_pau_nb745` DOUBLE, `flux_nl_t_pau_nb755` DOUBLE, `flux_nl_el_t_pau_nb755` DOUBLE, `flux_err_sigma_pau_nb755` DOUBLE, `flux_err_realization_pau_nb755` DOUBLE, `flux_t_pau_nb755` DOUBLE, `flux_el_t_pau_nb755` DOUBLE, `flux_nl_t_pau_nb765` DOUBLE, `flux_nl_el_t_pau_nb765` DOUBLE, `flux_err_sigma_pau_nb765` DOUBLE, `flux_err_realization_pau_nb765` DOUBLE, `flux_t_pau_nb765` DOUBLE, `flux_el_t_pau_nb765` DOUBLE, `flux_nl_t_pau_nb775` DOUBLE, `flux_nl_el_t_pau_nb775` DOUBLE, `flux_err_sigma_pau_nb775` DOUBLE, `flux_err_realization_pau_nb775` DOUBLE, `flux_t_pau_nb775` DOUBLE, `flux_el_t_pau_nb775` DOUBLE, `flux_nl_t_pau_nb785` DOUBLE, `flux_nl_el_t_pau_nb785` DOUBLE, `flux_err_sigma_pau_nb785` DOUBLE, `flux_err_realization_pau_nb785` DOUBLE, `flux_t_pau_nb785` DOUBLE, `flux_el_t_pau_nb785` DOUBLE, `flux_nl_t_pau_nb795` DOUBLE, `flux_nl_el_t_pau_nb795` DOUBLE, `flux_err_sigma_pau_nb795` DOUBLE, `flux_err_realization_pau_nb795` DOUBLE, `flux_t_pau_nb795` DOUBLE, `flux_el_t_pau_nb795` DOUBLE, `flux_nl_t_pau_nb805` DOUBLE, `flux_nl_el_t_pau_nb805` DOUBLE, `flux_err_sigma_pau_nb805` DOUBLE, `flux_err_realization_pau_nb805` DOUBLE, `flux_t_pau_nb805` DOUBLE, `flux_el_t_pau_nb805` DOUBLE, `flux_nl_t_pau_nb815` DOUBLE, `flux_nl_el_t_pau_nb815` DOUBLE, `flux_err_sigma_pau_nb815` DOUBLE, `flux_err_realization_pau_nb815` DOUBLE, `flux_t_pau_nb815` DOUBLE, `flux_el_t_pau_nb815` DOUBLE, `flux_nl_t_pau_nb825` DOUBLE, `flux_nl_el_t_pau_nb825` DOUBLE, `flux_err_sigma_pau_nb825` DOUBLE, `flux_err_realization_pau_nb825` DOUBLE, `flux_t_pau_nb825` DOUBLE, `flux_el_t_pau_nb825` DOUBLE, `flux_nl_t_pau_nb835` DOUBLE, `flux_nl_el_t_pau_nb835` DOUBLE, `flux_err_sigma_pau_nb835` DOUBLE, `flux_err_realization_pau_nb835` DOUBLE, `flux_t_pau_nb835` DOUBLE, `flux_el_t_pau_nb835` DOUBLE, `flux_nl_t_pau_nb845` DOUBLE, `flux_nl_el_t_pau_nb845` DOUBLE, `flux_err_sigma_pau_nb845` DOUBLE, `flux_err_realization_pau_nb845` DOUBLE, `flux_t_pau_nb845` DOUBLE, `flux_el_t_pau_nb845` DOUBLE, `flux_nl_t_pau_r` DOUBLE, `flux_nl_el_t_pau_r` DOUBLE, `flux_err_sigma_pau_r` DOUBLE, `flux_err_realization_pau_r` DOUBLE, `flux_t_pau_r` DOUBLE, `flux_el_t_pau_r` DOUBLE, `flux_nl_t_pau_u` DOUBLE, `flux_nl_el_t_pau_u` DOUBLE, `flux_err_sigma_pau_u` DOUBLE, `flux_err_realization_pau_u` DOUBLE, `flux_t_pau_u` DOUBLE, `flux_el_t_pau_u` DOUBLE, `flux_nl_t_pau_y` DOUBLE, `flux_nl_el_t_pau_y` DOUBLE, `flux_err_sigma_pau_y` DOUBLE, `flux_err_realization_pau_y` DOUBLE, `flux_t_pau_y` DOUBLE, `flux_el_t_pau_y` DOUBLE, `flux_nl_t_pau_z` DOUBLE, `flux_nl_el_t_pau_z` DOUBLE, `flux_err_sigma_pau_z` DOUBLE, `flux_err_realization_pau_z` DOUBLE, `flux_t_pau_z` DOUBLE, `flux_el_t_pau_z` DOUBLE, `flux_nl_t_sdss_g` DOUBLE, `flux_nl_el_t_sdss_g` DOUBLE, `flux_err_sigma_sdss_g` DOUBLE, `flux_err_realization_sdss_g` DOUBLE, `flux_t_sdss_g` DOUBLE, `flux_el_t_sdss_g` DOUBLE, `flux_nl_t_sdss_i` DOUBLE, `flux_nl_el_t_sdss_i` DOUBLE, `flux_err_sigma_sdss_i` DOUBLE, `flux_err_realization_sdss_i` DOUBLE, `flux_t_sdss_i` DOUBLE, `flux_el_t_sdss_i` DOUBLE, `flux_nl_t_sdss_r` DOUBLE, `flux_nl_el_t_sdss_r` DOUBLE, `flux_err_sigma_sdss_r` DOUBLE, `flux_err_realization_sdss_r` DOUBLE, `flux_t_sdss_r` DOUBLE, `flux_el_t_sdss_r` DOUBLE, `flux_nl_t_sdss_u` DOUBLE, `flux_nl_el_t_sdss_u` DOUBLE, `flux_err_sigma_sdss_u` DOUBLE, `flux_err_realization_sdss_u` DOUBLE, `flux_t_sdss_u` DOUBLE, `flux_el_t_sdss_u` DOUBLE, `flux_nl_t_sdss_z` DOUBLE, `flux_nl_el_t_sdss_z` DOUBLE, `flux_err_sigma_sdss_z` DOUBLE, `flux_err_realization_sdss_z` DOUBLE, `flux_t_sdss_z` DOUBLE, `flux_el_t_sdss_z` DOUBLE, `flux_nl_t_subaru_b` DOUBLE, `flux_nl_el_t_subaru_b` DOUBLE, `flux_err_sigma_subaru_b` DOUBLE, `flux_err_realization_subaru_b` DOUBLE, `flux_t_subaru_b` DOUBLE, `flux_el_t_subaru_b` DOUBLE, `flux_nl_t_subaru_i` DOUBLE, `flux_nl_el_t_subaru_i` DOUBLE, `flux_err_sigma_subaru_i` DOUBLE, `flux_err_realization_subaru_i` DOUBLE, `flux_t_subaru_i` DOUBLE, `flux_el_t_subaru_i` DOUBLE, `flux_nl_t_subaru_ia427` DOUBLE, `flux_nl_el_t_subaru_ia427` DOUBLE, `flux_err_sigma_subaru_ia427` DOUBLE, `flux_err_realization_subaru_ia427` DOUBLE, `flux_t_subaru_ia427` DOUBLE, `flux_el_t_subaru_ia427` DOUBLE, `flux_nl_t_subaru_ia464` DOUBLE, `flux_nl_el_t_subaru_ia464` DOUBLE, `flux_err_sigma_subaru_ia464` DOUBLE, `flux_err_realization_subaru_ia464` DOUBLE, `flux_t_subaru_ia464` DOUBLE, `flux_el_t_subaru_ia464` DOUBLE, `flux_nl_t_subaru_ia484` DOUBLE, `flux_nl_el_t_subaru_ia484` DOUBLE, `flux_err_sigma_subaru_ia484` DOUBLE, `flux_err_realization_subaru_ia484` DOUBLE, `flux_t_subaru_ia484` DOUBLE, `flux_el_t_subaru_ia484` DOUBLE, `flux_nl_t_subaru_ia505` DOUBLE, `flux_nl_el_t_subaru_ia505` DOUBLE, `flux_err_sigma_subaru_ia505` DOUBLE, `flux_err_realization_subaru_ia505` DOUBLE, `flux_t_subaru_ia505` DOUBLE, `flux_el_t_subaru_ia505` DOUBLE, `flux_nl_t_subaru_ia527` DOUBLE, `flux_nl_el_t_subaru_ia527` DOUBLE, `flux_err_sigma_subaru_ia527` DOUBLE, `flux_err_realization_subaru_ia527` DOUBLE, `flux_t_subaru_ia527` DOUBLE, `flux_el_t_subaru_ia527` DOUBLE, `flux_nl_t_subaru_ia574` DOUBLE, `flux_nl_el_t_subaru_ia574` DOUBLE, `flux_err_sigma_subaru_ia574` DOUBLE, `flux_err_realization_subaru_ia574` DOUBLE, `flux_t_subaru_ia574` DOUBLE, `flux_el_t_subaru_ia574` DOUBLE, `flux_nl_t_subaru_ia624` DOUBLE, `flux_nl_el_t_subaru_ia624` DOUBLE, `flux_err_sigma_subaru_ia624` DOUBLE, `flux_err_realization_subaru_ia624` DOUBLE, `flux_t_subaru_ia624` DOUBLE, `flux_el_t_subaru_ia624` DOUBLE, `flux_nl_t_subaru_ia679` DOUBLE, `flux_nl_el_t_subaru_ia679` DOUBLE, `flux_err_sigma_subaru_ia679` DOUBLE, `flux_err_realization_subaru_ia679` DOUBLE, `flux_t_subaru_ia679` DOUBLE, `flux_el_t_subaru_ia679` DOUBLE, `flux_nl_t_subaru_ia709` DOUBLE, `flux_nl_el_t_subaru_ia709` DOUBLE, `flux_err_sigma_subaru_ia709` DOUBLE, `flux_err_realization_subaru_ia709` DOUBLE, `flux_t_subaru_ia709` DOUBLE, `flux_el_t_subaru_ia709` DOUBLE, `flux_nl_t_subaru_ia738` DOUBLE, `flux_nl_el_t_subaru_ia738` DOUBLE, `flux_err_sigma_subaru_ia738` DOUBLE, `flux_err_realization_subaru_ia738` DOUBLE, `flux_t_subaru_ia738` DOUBLE, `flux_el_t_subaru_ia738` DOUBLE, `flux_nl_t_subaru_ia767` DOUBLE, `flux_nl_el_t_subaru_ia767` DOUBLE, `flux_err_sigma_subaru_ia767` DOUBLE, `flux_err_realization_subaru_ia767` DOUBLE, `flux_t_subaru_ia767` DOUBLE, `flux_el_t_subaru_ia767` DOUBLE, `flux_nl_t_subaru_ia827` DOUBLE, `flux_nl_el_t_subaru_ia827` DOUBLE, `flux_err_sigma_subaru_ia827` DOUBLE, `flux_err_realization_subaru_ia827` DOUBLE, `flux_t_subaru_ia827` DOUBLE, `flux_el_t_subaru_ia827` DOUBLE, `flux_nl_t_subaru_nb711` DOUBLE, `flux_nl_el_t_subaru_nb711` DOUBLE, `flux_err_sigma_subaru_nb711` DOUBLE, `flux_err_realization_subaru_nb711` DOUBLE, `flux_t_subaru_nb711` DOUBLE, `flux_el_t_subaru_nb711` DOUBLE, `flux_nl_t_subaru_nb816` DOUBLE, `flux_nl_el_t_subaru_nb816` DOUBLE, `flux_err_sigma_subaru_nb816` DOUBLE, `flux_err_realization_subaru_nb816` DOUBLE, `flux_t_subaru_nb816` DOUBLE, `flux_el_t_subaru_nb816` DOUBLE, `flux_nl_t_subaru_r` DOUBLE, `flux_nl_el_t_subaru_r` DOUBLE, `flux_err_sigma_subaru_r` DOUBLE, `flux_err_realization_subaru_r` DOUBLE, `flux_t_subaru_r` DOUBLE, `flux_el_t_subaru_r` DOUBLE, `flux_nl_t_subaru_v` DOUBLE, `flux_nl_el_t_subaru_v` DOUBLE, `flux_err_sigma_subaru_v` DOUBLE, `flux_err_realization_subaru_v` DOUBLE, `flux_t_subaru_v` DOUBLE, `flux_el_t_subaru_v` DOUBLE, `flux_nl_t_subaru_y` DOUBLE, `flux_nl_el_t_subaru_y` DOUBLE, `flux_err_sigma_subaru_y` DOUBLE, `flux_err_realization_subaru_y` DOUBLE, `flux_t_subaru_y` DOUBLE, `flux_el_t_subaru_y` DOUBLE, `flux_nl_t_subaru_z` DOUBLE, `flux_nl_el_t_subaru_z` DOUBLE, `flux_err_sigma_subaru_z` DOUBLE, `flux_err_realization_subaru_z` DOUBLE, `flux_t_subaru_z` DOUBLE, `flux_el_t_subaru_z` DOUBLE, `flux_nl_t_vista_h` DOUBLE, `flux_nl_el_t_vista_h` DOUBLE, `flux_err_sigma_vista_h` DOUBLE, `flux_err_realization_vista_h` DOUBLE, `flux_t_vista_h` DOUBLE, `flux_el_t_vista_h` DOUBLE, `flux_nl_t_vista_j` DOUBLE, `flux_nl_el_t_vista_j` DOUBLE, `flux_err_sigma_vista_j` DOUBLE, `flux_err_realization_vista_j` DOUBLE, `flux_t_vista_j` DOUBLE, `flux_el_t_vista_j` DOUBLE, `flux_nl_t_vista_ks` DOUBLE, `flux_nl_el_t_vista_ks` DOUBLE, `flux_err_sigma_vista_ks` DOUBLE, `flux_err_realization_vista_ks` DOUBLE, `flux_t_vista_ks` DOUBLE, `flux_el_t_vista_ks` DOUBLE, `flux_nl_t_vista_y` DOUBLE, `flux_nl_el_t_vista_y` DOUBLE, `flux_err_sigma_vista_y` DOUBLE, `flux_err_realization_vista_y` DOUBLE, `flux_t_vista_y` DOUBLE, `flux_el_t_vista_y` DOUBLE, `flux_nl_t_wircam_h` DOUBLE, `flux_nl_el_t_wircam_h` DOUBLE, `flux_err_sigma_wircam_h` DOUBLE, `flux_err_realization_wircam_h` DOUBLE, `flux_t_wircam_h` DOUBLE, `flux_el_t_wircam_h` DOUBLE, `flux_nl_t_wircam_ks` DOUBLE, `flux_nl_el_t_wircam_ks` DOUBLE, `flux_err_sigma_wircam_ks` DOUBLE, `flux_err_realization_wircam_ks` DOUBLE, `flux_t_wircam_ks` DOUBLE, `flux_el_t_wircam_ks` DOUBLE, `halo_id` BIGINT, `galaxy_id` BIGINT
) STORED AS PARQUET LOCATION '/user/jcarrete/data/euclid/flagship_paus_20200527'
An example:
SELECT `flux_nl_t_pau_nb455`, `flux_nl_el_t_pau_nb455`, `flux_err_sigma_pau_nb455`, `flux_err_realization_pau_nb455`, `flux_el_t_pau_nb455`, `flux_t_pau_nb455` FROM jcarrete.pau_flagship_1_8_4_v0_3_pq LIMIT 10;
I create the ORC table:
CREATE TABLE cosmohub.pau_flagship_1_8_4_v0_3_c (
`halo_id` BIGINT, `galaxy_id` INT, `ra_gal` FLOAT, `dec_gal` FLOAT, `sed_cosmos` FLOAT, `ext_curve_cosmos` INT, `ebv_cosmos` FLOAT, `true_redshift_gal` FLOAT, `observed_redshift_gal` FLOAT, `abs_mag_r01_evolved` FLOAT, `logf_halpha_ext` FLOAT, `logf_hbeta_ext` FLOAT, `logf_o2_ext` FLOAT, `logf_n2_ext` FLOAT, `logf_o3_ext` FLOAT, `logf_s2_ext` FLOAT, `flux_nl_t_blanco_decam_g` FLOAT, `flux_nl_el_t_blanco_decam_g` FLOAT, `flux_err_sigma_blanco_decam_g` FLOAT, `flux_err_realization_blanco_decam_g` FLOAT, `flux_t_blanco_decam_g` FLOAT, `flux_el_t_blanco_decam_g` FLOAT, `flux_nl_t_blanco_decam_i` FLOAT, `flux_nl_el_t_blanco_decam_i` FLOAT, `flux_err_sigma_blanco_decam_i` FLOAT, `flux_err_realization_blanco_decam_i` FLOAT, `flux_t_blanco_decam_i` FLOAT, `flux_el_t_blanco_decam_i` FLOAT, `flux_nl_t_blanco_decam_r` FLOAT, `flux_nl_el_t_blanco_decam_r` FLOAT, `flux_err_sigma_blanco_decam_r` FLOAT, `flux_err_realization_blanco_decam_r` FLOAT, `flux_t_blanco_decam_r` FLOAT, `flux_el_t_blanco_decam_r` FLOAT, `flux_nl_t_blanco_decam_z` FLOAT, `flux_nl_el_t_blanco_decam_z` FLOAT, `flux_err_sigma_blanco_decam_z` FLOAT, `flux_err_realization_blanco_decam_z` FLOAT, `flux_t_blanco_decam_z` FLOAT, `flux_el_t_blanco_decam_z` FLOAT, `flux_nl_t_cfht_megacam_g_1` FLOAT, `flux_nl_el_t_cfht_megacam_g_1` FLOAT, `flux_err_sigma_cfht_megacam_g_1` FLOAT, `flux_err_realization_cfht_megacam_g_1` FLOAT, `flux_t_cfht_megacam_g_1` FLOAT, `flux_el_t_cfht_megacam_g_1` FLOAT, `flux_nl_t_cfht_megacam_i_1` FLOAT, `flux_nl_el_t_cfht_megacam_i_1` FLOAT, `flux_err_sigma_cfht_megacam_i_1` FLOAT, `flux_err_realization_cfht_megacam_i_1` FLOAT, `flux_t_cfht_megacam_i_1` FLOAT, `flux_el_t_cfht_megacam_i_1` FLOAT, `flux_nl_t_cfht_megacam_r_1` FLOAT, `flux_nl_el_t_cfht_megacam_r_1` FLOAT, `flux_err_sigma_cfht_megacam_r_1` FLOAT, `flux_err_realization_cfht_megacam_r_1` FLOAT, `flux_t_cfht_megacam_r_1` FLOAT, `flux_el_t_cfht_megacam_r_1` FLOAT, `flux_nl_t_cfht_megacam_u_1` FLOAT, `flux_nl_el_t_cfht_megacam_u_1` FLOAT, `flux_err_sigma_cfht_megacam_u_1` FLOAT, `flux_err_realization_cfht_megacam_u_1` FLOAT, `flux_t_cfht_megacam_u_1` FLOAT, `flux_el_t_cfht_megacam_u_1` FLOAT, `flux_nl_t_cfht_megacam_z_1` FLOAT, `flux_nl_el_t_cfht_megacam_z_1` FLOAT, `flux_err_sigma_cfht_megacam_z_1` FLOAT, `flux_err_realization_cfht_megacam_z_1` FLOAT, `flux_t_cfht_megacam_z_1` FLOAT, `flux_el_t_cfht_megacam_z_1` FLOAT, `flux_nl_t_cfht_u` FLOAT, `flux_nl_el_t_cfht_u` FLOAT, `flux_err_sigma_cfht_u` FLOAT, `flux_err_realization_cfht_u` FLOAT, `flux_t_cfht_u` FLOAT, `flux_el_t_cfht_u` FLOAT, `flux_nl_t_euclid_nisp_h` FLOAT, `flux_nl_el_t_euclid_nisp_h` FLOAT, `flux_err_sigma_euclid_nisp_h` FLOAT, `flux_err_realization_euclid_nisp_h` FLOAT, `flux_t_euclid_nisp_h` FLOAT, `flux_el_t_euclid_nisp_h` FLOAT, `flux_nl_t_euclid_nisp_j` FLOAT, `flux_nl_el_t_euclid_nisp_j` FLOAT, `flux_err_sigma_euclid_nisp_j` FLOAT, `flux_err_realization_euclid_nisp_j` FLOAT, `flux_t_euclid_nisp_j` FLOAT, `flux_el_t_euclid_nisp_j` FLOAT, `flux_nl_t_euclid_nisp_y` FLOAT, `flux_nl_el_t_euclid_nisp_y` FLOAT, `flux_err_sigma_euclid_nisp_y` FLOAT, `flux_err_realization_euclid_nisp_y` FLOAT, `flux_t_euclid_nisp_y` FLOAT, `flux_el_t_euclid_nisp_y` FLOAT, `flux_nl_t_euclid_vis` FLOAT, `flux_nl_el_t_euclid_vis` FLOAT, `flux_err_sigma_euclid_vis` FLOAT, `flux_err_realization_euclid_vis` FLOAT, `flux_t_euclid_vis` FLOAT, `flux_el_t_euclid_vis` FLOAT, `flux_nl_t_galex_nuv` FLOAT, `flux_nl_el_t_galex_nuv` FLOAT, `flux_err_sigma_galex_nuv` FLOAT, `flux_err_realization_galex_nuv` FLOAT, `flux_t_galex_nuv` FLOAT, `flux_el_t_galex_nuv` FLOAT, `flux_nl_t_pau_g` FLOAT, `flux_nl_el_t_pau_g` FLOAT, `flux_err_sigma_pau_g` FLOAT, `flux_err_realization_pau_g` FLOAT, `flux_t_pau_g` FLOAT, `flux_el_t_pau_g` FLOAT, `flux_nl_t_pau_i` FLOAT, `flux_nl_el_t_pau_i` FLOAT, `flux_err_sigma_pau_i` FLOAT, `flux_err_realization_pau_i` FLOAT, `flux_t_pau_i` FLOAT, `flux_el_t_pau_i` FLOAT, `flux_nl_t_pau_nb455` FLOAT, `flux_nl_el_t_pau_nb455` FLOAT, `flux_err_sigma_pau_nb455` FLOAT, `flux_err_realization_pau_nb455` FLOAT, `flux_t_pau_nb455` FLOAT, `flux_el_t_pau_nb455` FLOAT, `flux_nl_t_pau_nb465` FLOAT, `flux_nl_el_t_pau_nb465` FLOAT, `flux_err_sigma_pau_nb465` FLOAT, `flux_err_realization_pau_nb465` FLOAT, `flux_t_pau_nb465` FLOAT, `flux_el_t_pau_nb465` FLOAT, `flux_nl_t_pau_nb475` FLOAT, `flux_nl_el_t_pau_nb475` FLOAT, `flux_err_sigma_pau_nb475` FLOAT, `flux_err_realization_pau_nb475` FLOAT, `flux_t_pau_nb475` FLOAT, `flux_el_t_pau_nb475` FLOAT, `flux_nl_t_pau_nb485` FLOAT, `flux_nl_el_t_pau_nb485` FLOAT, `flux_err_sigma_pau_nb485` FLOAT, `flux_err_realization_pau_nb485` FLOAT, `flux_t_pau_nb485` FLOAT, `flux_el_t_pau_nb485` FLOAT, `flux_nl_t_pau_nb495` FLOAT, `flux_nl_el_t_pau_nb495` FLOAT, `flux_err_sigma_pau_nb495` FLOAT, `flux_err_realization_pau_nb495` FLOAT, `flux_t_pau_nb495` FLOAT, `flux_el_t_pau_nb495` FLOAT, `flux_nl_t_pau_nb505` FLOAT, `flux_nl_el_t_pau_nb505` FLOAT, `flux_err_sigma_pau_nb505` FLOAT, `flux_err_realization_pau_nb505` FLOAT, `flux_t_pau_nb505` FLOAT, `flux_el_t_pau_nb505` FLOAT, `flux_nl_t_pau_nb515` FLOAT, `flux_nl_el_t_pau_nb515` FLOAT, `flux_err_sigma_pau_nb515` FLOAT, `flux_err_realization_pau_nb515` FLOAT, `flux_t_pau_nb515` FLOAT, `flux_el_t_pau_nb515` FLOAT, `flux_nl_t_pau_nb525` FLOAT, `flux_nl_el_t_pau_nb525` FLOAT, `flux_err_sigma_pau_nb525` FLOAT, `flux_err_realization_pau_nb525` FLOAT, `flux_t_pau_nb525` FLOAT, `flux_el_t_pau_nb525` FLOAT, `flux_nl_t_pau_nb535` FLOAT, `flux_nl_el_t_pau_nb535` FLOAT, `flux_err_sigma_pau_nb535` FLOAT, `flux_err_realization_pau_nb535` FLOAT, `flux_t_pau_nb535` FLOAT, `flux_el_t_pau_nb535` FLOAT, `flux_nl_t_pau_nb545` FLOAT, `flux_nl_el_t_pau_nb545` FLOAT, `flux_err_sigma_pau_nb545` FLOAT, `flux_err_realization_pau_nb545` FLOAT, `flux_t_pau_nb545` FLOAT, `flux_el_t_pau_nb545` FLOAT, `flux_nl_t_pau_nb555` FLOAT, `flux_nl_el_t_pau_nb555` FLOAT, `flux_err_sigma_pau_nb555` FLOAT, `flux_err_realization_pau_nb555` FLOAT, `flux_t_pau_nb555` FLOAT, `flux_el_t_pau_nb555` FLOAT, `flux_nl_t_pau_nb565` FLOAT, `flux_nl_el_t_pau_nb565` FLOAT, `flux_err_sigma_pau_nb565` FLOAT, `flux_err_realization_pau_nb565` FLOAT, `flux_t_pau_nb565` FLOAT, `flux_el_t_pau_nb565` FLOAT, `flux_nl_t_pau_nb575` FLOAT, `flux_nl_el_t_pau_nb575` FLOAT, `flux_err_sigma_pau_nb575` FLOAT, `flux_err_realization_pau_nb575` FLOAT, `flux_t_pau_nb575` FLOAT, `flux_el_t_pau_nb575` FLOAT, `flux_nl_t_pau_nb585` FLOAT, `flux_nl_el_t_pau_nb585` FLOAT, `flux_err_sigma_pau_nb585` FLOAT, `flux_err_realization_pau_nb585` FLOAT, `flux_t_pau_nb585` FLOAT, `flux_el_t_pau_nb585` FLOAT, `flux_nl_t_pau_nb595` FLOAT, `flux_nl_el_t_pau_nb595` FLOAT, `flux_err_sigma_pau_nb595` FLOAT, `flux_err_realization_pau_nb595` FLOAT, `flux_t_pau_nb595` FLOAT, `flux_el_t_pau_nb595` FLOAT, `flux_nl_t_pau_nb605` FLOAT, `flux_nl_el_t_pau_nb605` FLOAT, `flux_err_sigma_pau_nb605` FLOAT, `flux_err_realization_pau_nb605` FLOAT, `flux_t_pau_nb605` FLOAT, `flux_el_t_pau_nb605` FLOAT, `flux_nl_t_pau_nb615` FLOAT, `flux_nl_el_t_pau_nb615` FLOAT, `flux_err_sigma_pau_nb615` FLOAT, `flux_err_realization_pau_nb615` FLOAT, `flux_t_pau_nb615` FLOAT, `flux_el_t_pau_nb615` FLOAT, `flux_nl_t_pau_nb625` FLOAT, `flux_nl_el_t_pau_nb625` FLOAT, `flux_err_sigma_pau_nb625` FLOAT, `flux_err_realization_pau_nb625` FLOAT, `flux_t_pau_nb625` FLOAT, `flux_el_t_pau_nb625` FLOAT, `flux_nl_t_pau_nb635` FLOAT, `flux_nl_el_t_pau_nb635` FLOAT, `flux_err_sigma_pau_nb635` FLOAT, `flux_err_realization_pau_nb635` FLOAT, `flux_t_pau_nb635` FLOAT, `flux_el_t_pau_nb635` FLOAT, `flux_nl_t_pau_nb645` FLOAT, `flux_nl_el_t_pau_nb645` FLOAT, `flux_err_sigma_pau_nb645` FLOAT, `flux_err_realization_pau_nb645` FLOAT, `flux_t_pau_nb645` FLOAT, `flux_el_t_pau_nb645` FLOAT, `flux_nl_t_pau_nb655` FLOAT, `flux_nl_el_t_pau_nb655` FLOAT, `flux_err_sigma_pau_nb655` FLOAT, `flux_err_realization_pau_nb655` FLOAT, `flux_t_pau_nb655` FLOAT, `flux_el_t_pau_nb655` FLOAT, `flux_nl_t_pau_nb665` FLOAT, `flux_nl_el_t_pau_nb665` FLOAT, `flux_err_sigma_pau_nb665` FLOAT, `flux_err_realization_pau_nb665` FLOAT, `flux_t_pau_nb665` FLOAT, `flux_el_t_pau_nb665` FLOAT, `flux_nl_t_pau_nb675` FLOAT, `flux_nl_el_t_pau_nb675` FLOAT, `flux_err_sigma_pau_nb675` FLOAT, `flux_err_realization_pau_nb675` FLOAT, `flux_t_pau_nb675` FLOAT, `flux_el_t_pau_nb675` FLOAT, `flux_nl_t_pau_nb685` FLOAT, `flux_nl_el_t_pau_nb685` FLOAT, `flux_err_sigma_pau_nb685` FLOAT, `flux_err_realization_pau_nb685` FLOAT, `flux_t_pau_nb685` FLOAT, `flux_el_t_pau_nb685` FLOAT, `flux_nl_t_pau_nb695` FLOAT, `flux_nl_el_t_pau_nb695` FLOAT, `flux_err_sigma_pau_nb695` FLOAT, `flux_err_realization_pau_nb695` FLOAT, `flux_t_pau_nb695` FLOAT, `flux_el_t_pau_nb695` FLOAT, `flux_nl_t_pau_nb705` FLOAT, `flux_nl_el_t_pau_nb705` FLOAT, `flux_err_sigma_pau_nb705` FLOAT, `flux_err_realization_pau_nb705` FLOAT, `flux_t_pau_nb705` FLOAT, `flux_el_t_pau_nb705` FLOAT, `flux_nl_t_pau_nb715` FLOAT, `flux_nl_el_t_pau_nb715` FLOAT, `flux_err_sigma_pau_nb715` FLOAT, `flux_err_realization_pau_nb715` FLOAT, `flux_t_pau_nb715` FLOAT, `flux_el_t_pau_nb715` FLOAT, `flux_nl_t_pau_nb725` FLOAT, `flux_nl_el_t_pau_nb725` FLOAT, `flux_err_sigma_pau_nb725` FLOAT, `flux_err_realization_pau_nb725` FLOAT, `flux_t_pau_nb725` FLOAT, `flux_el_t_pau_nb725` FLOAT, `flux_nl_t_pau_nb735` FLOAT, `flux_nl_el_t_pau_nb735` FLOAT, `flux_err_sigma_pau_nb735` FLOAT, `flux_err_realization_pau_nb735` FLOAT, `flux_t_pau_nb735` FLOAT, `flux_el_t_pau_nb735` FLOAT, `flux_nl_t_pau_nb745` FLOAT, `flux_nl_el_t_pau_nb745` FLOAT, `flux_err_sigma_pau_nb745` FLOAT, `flux_err_realization_pau_nb745` FLOAT, `flux_t_pau_nb745` FLOAT, `flux_el_t_pau_nb745` FLOAT, `flux_nl_t_pau_nb755` FLOAT, `flux_nl_el_t_pau_nb755` FLOAT, `flux_err_sigma_pau_nb755` FLOAT, `flux_err_realization_pau_nb755` FLOAT, `flux_t_pau_nb755` FLOAT, `flux_el_t_pau_nb755` FLOAT, `flux_nl_t_pau_nb765` FLOAT, `flux_nl_el_t_pau_nb765` FLOAT, `flux_err_sigma_pau_nb765` FLOAT, `flux_err_realization_pau_nb765` FLOAT, `flux_t_pau_nb765` FLOAT, `flux_el_t_pau_nb765` FLOAT, `flux_nl_t_pau_nb775` FLOAT, `flux_nl_el_t_pau_nb775` FLOAT, `flux_err_sigma_pau_nb775` FLOAT, `flux_err_realization_pau_nb775` FLOAT, `flux_t_pau_nb775` FLOAT, `flux_el_t_pau_nb775` FLOAT, `flux_nl_t_pau_nb785` FLOAT, `flux_nl_el_t_pau_nb785` FLOAT, `flux_err_sigma_pau_nb785` FLOAT, `flux_err_realization_pau_nb785` FLOAT, `flux_t_pau_nb785` FLOAT, `flux_el_t_pau_nb785` FLOAT, `flux_nl_t_pau_nb795` FLOAT, `flux_nl_el_t_pau_nb795` FLOAT, `flux_err_sigma_pau_nb795` FLOAT, `flux_err_realization_pau_nb795` FLOAT, `flux_t_pau_nb795` FLOAT, `flux_el_t_pau_nb795` FLOAT, `flux_nl_t_pau_nb805` FLOAT, `flux_nl_el_t_pau_nb805` FLOAT, `flux_err_sigma_pau_nb805` FLOAT, `flux_err_realization_pau_nb805` FLOAT, `flux_t_pau_nb805` FLOAT, `flux_el_t_pau_nb805` FLOAT, `flux_nl_t_pau_nb815` FLOAT, `flux_nl_el_t_pau_nb815` FLOAT, `flux_err_sigma_pau_nb815` FLOAT, `flux_err_realization_pau_nb815` FLOAT, `flux_t_pau_nb815` FLOAT, `flux_el_t_pau_nb815` FLOAT, `flux_nl_t_pau_nb825` FLOAT, `flux_nl_el_t_pau_nb825` FLOAT, `flux_err_sigma_pau_nb825` FLOAT, `flux_err_realization_pau_nb825` FLOAT, `flux_t_pau_nb825` FLOAT, `flux_el_t_pau_nb825` FLOAT, `flux_nl_t_pau_nb835` FLOAT, `flux_nl_el_t_pau_nb835` FLOAT, `flux_err_sigma_pau_nb835` FLOAT, `flux_err_realization_pau_nb835` FLOAT, `flux_t_pau_nb835` FLOAT, `flux_el_t_pau_nb835` FLOAT, `flux_nl_t_pau_nb845` FLOAT, `flux_nl_el_t_pau_nb845` FLOAT, `flux_err_sigma_pau_nb845` FLOAT, `flux_err_realization_pau_nb845` FLOAT, `flux_t_pau_nb845` FLOAT, `flux_el_t_pau_nb845` FLOAT, `flux_nl_t_pau_r` FLOAT, `flux_nl_el_t_pau_r` FLOAT, `flux_err_sigma_pau_r` FLOAT, `flux_err_realization_pau_r` FLOAT, `flux_t_pau_r` FLOAT, `flux_el_t_pau_r` FLOAT, `flux_nl_t_pau_u` FLOAT, `flux_nl_el_t_pau_u` FLOAT, `flux_err_sigma_pau_u` FLOAT, `flux_err_realization_pau_u` FLOAT, `flux_t_pau_u` FLOAT, `flux_el_t_pau_u` FLOAT, `flux_nl_t_pau_y` FLOAT, `flux_nl_el_t_pau_y` FLOAT, `flux_err_sigma_pau_y` FLOAT, `flux_err_realization_pau_y` FLOAT, `flux_t_pau_y` FLOAT, `flux_el_t_pau_y` FLOAT, `flux_nl_t_pau_z` FLOAT, `flux_nl_el_t_pau_z` FLOAT, `flux_err_sigma_pau_z` FLOAT, `flux_err_realization_pau_z` FLOAT, `flux_t_pau_z` FLOAT, `flux_el_t_pau_z` FLOAT, `flux_nl_t_sdss_g` FLOAT, `flux_nl_el_t_sdss_g` FLOAT, `flux_err_sigma_sdss_g` FLOAT, `flux_err_realization_sdss_g` FLOAT, `flux_t_sdss_g` FLOAT, `flux_el_t_sdss_g` FLOAT, `flux_nl_t_sdss_i` FLOAT, `flux_nl_el_t_sdss_i` FLOAT, `flux_err_sigma_sdss_i` FLOAT, `flux_err_realization_sdss_i` FLOAT, `flux_t_sdss_i` FLOAT, `flux_el_t_sdss_i` FLOAT, `flux_nl_t_sdss_r` FLOAT, `flux_nl_el_t_sdss_r` FLOAT, `flux_err_sigma_sdss_r` FLOAT, `flux_err_realization_sdss_r` FLOAT, `flux_t_sdss_r` FLOAT, `flux_el_t_sdss_r` FLOAT, `flux_nl_t_sdss_u` FLOAT, `flux_nl_el_t_sdss_u` FLOAT, `flux_err_sigma_sdss_u` FLOAT, `flux_err_realization_sdss_u` FLOAT, `flux_t_sdss_u` FLOAT, `flux_el_t_sdss_u` FLOAT, `flux_nl_t_sdss_z` FLOAT, `flux_nl_el_t_sdss_z` FLOAT, `flux_err_sigma_sdss_z` FLOAT, `flux_err_realization_sdss_z` FLOAT, `flux_t_sdss_z` FLOAT, `flux_el_t_sdss_z` FLOAT, `flux_nl_t_subaru_b` FLOAT, `flux_nl_el_t_subaru_b` FLOAT, `flux_err_sigma_subaru_b` FLOAT, `flux_err_realization_subaru_b` FLOAT, `flux_t_subaru_b` FLOAT, `flux_el_t_subaru_b` FLOAT, `flux_nl_t_subaru_i` FLOAT, `flux_nl_el_t_subaru_i` FLOAT, `flux_err_sigma_subaru_i` FLOAT, `flux_err_realization_subaru_i` FLOAT, `flux_t_subaru_i` FLOAT, `flux_el_t_subaru_i` FLOAT, `flux_nl_t_subaru_ia427` FLOAT, `flux_nl_el_t_subaru_ia427` FLOAT, `flux_err_sigma_subaru_ia427` FLOAT, `flux_err_realization_subaru_ia427` FLOAT, `flux_t_subaru_ia427` FLOAT, `flux_el_t_subaru_ia427` FLOAT, `flux_nl_t_subaru_ia464` FLOAT, `flux_nl_el_t_subaru_ia464` FLOAT, `flux_err_sigma_subaru_ia464` FLOAT, `flux_err_realization_subaru_ia464` FLOAT, `flux_t_subaru_ia464` FLOAT, `flux_el_t_subaru_ia464` FLOAT, `flux_nl_t_subaru_ia484` FLOAT, `flux_nl_el_t_subaru_ia484` FLOAT, `flux_err_sigma_subaru_ia484` FLOAT, `flux_err_realization_subaru_ia484` FLOAT, `flux_t_subaru_ia484` FLOAT, `flux_el_t_subaru_ia484` FLOAT, `flux_nl_t_subaru_ia505` FLOAT, `flux_nl_el_t_subaru_ia505` FLOAT, `flux_err_sigma_subaru_ia505` FLOAT, `flux_err_realization_subaru_ia505` FLOAT, `flux_t_subaru_ia505` FLOAT, `flux_el_t_subaru_ia505` FLOAT, `flux_nl_t_subaru_ia527` FLOAT, `flux_nl_el_t_subaru_ia527` FLOAT, `flux_err_sigma_subaru_ia527` FLOAT, `flux_err_realization_subaru_ia527` FLOAT, `flux_t_subaru_ia527` FLOAT, `flux_el_t_subaru_ia527` FLOAT, `flux_nl_t_subaru_ia574` FLOAT, `flux_nl_el_t_subaru_ia574` FLOAT, `flux_err_sigma_subaru_ia574` FLOAT, `flux_err_realization_subaru_ia574` FLOAT, `flux_t_subaru_ia574` FLOAT, `flux_el_t_subaru_ia574` FLOAT, `flux_nl_t_subaru_ia624` FLOAT, `flux_nl_el_t_subaru_ia624` FLOAT, `flux_err_sigma_subaru_ia624` FLOAT, `flux_err_realization_subaru_ia624` FLOAT, `flux_t_subaru_ia624` FLOAT, `flux_el_t_subaru_ia624` FLOAT, `flux_nl_t_subaru_ia679` FLOAT, `flux_nl_el_t_subaru_ia679` FLOAT, `flux_err_sigma_subaru_ia679` FLOAT, `flux_err_realization_subaru_ia679` FLOAT, `flux_t_subaru_ia679` FLOAT, `flux_el_t_subaru_ia679` FLOAT, `flux_nl_t_subaru_ia709` FLOAT, `flux_nl_el_t_subaru_ia709` FLOAT, `flux_err_sigma_subaru_ia709` FLOAT, `flux_err_realization_subaru_ia709` FLOAT, `flux_t_subaru_ia709` FLOAT, `flux_el_t_subaru_ia709` FLOAT, `flux_nl_t_subaru_ia738` FLOAT, `flux_nl_el_t_subaru_ia738` FLOAT, `flux_err_sigma_subaru_ia738` FLOAT, `flux_err_realization_subaru_ia738` FLOAT, `flux_t_subaru_ia738` FLOAT, `flux_el_t_subaru_ia738` FLOAT, `flux_nl_t_subaru_ia767` FLOAT, `flux_nl_el_t_subaru_ia767` FLOAT, `flux_err_sigma_subaru_ia767` FLOAT, `flux_err_realization_subaru_ia767` FLOAT, `flux_t_subaru_ia767` FLOAT, `flux_el_t_subaru_ia767` FLOAT, `flux_nl_t_subaru_ia827` FLOAT, `flux_nl_el_t_subaru_ia827` FLOAT, `flux_err_sigma_subaru_ia827` FLOAT, `flux_err_realization_subaru_ia827` FLOAT, `flux_t_subaru_ia827` FLOAT, `flux_el_t_subaru_ia827` FLOAT, `flux_nl_t_subaru_nb711` FLOAT, `flux_nl_el_t_subaru_nb711` FLOAT, `flux_err_sigma_subaru_nb711` FLOAT, `flux_err_realization_subaru_nb711` FLOAT, `flux_t_subaru_nb711` FLOAT, `flux_el_t_subaru_nb711` FLOAT, `flux_nl_t_subaru_nb816` FLOAT, `flux_nl_el_t_subaru_nb816` FLOAT, `flux_err_sigma_subaru_nb816` FLOAT, `flux_err_realization_subaru_nb816` FLOAT, `flux_t_subaru_nb816` FLOAT, `flux_el_t_subaru_nb816` FLOAT, `flux_nl_t_subaru_r` FLOAT, `flux_nl_el_t_subaru_r` FLOAT, `flux_err_sigma_subaru_r` FLOAT, `flux_err_realization_subaru_r` FLOAT, `flux_t_subaru_r` FLOAT, `flux_el_t_subaru_r` FLOAT, `flux_nl_t_subaru_v` FLOAT, `flux_nl_el_t_subaru_v` FLOAT, `flux_err_sigma_subaru_v` FLOAT, `flux_err_realization_subaru_v` FLOAT, `flux_t_subaru_v` FLOAT, `flux_el_t_subaru_v` FLOAT, `flux_nl_t_subaru_y` FLOAT, `flux_nl_el_t_subaru_y` FLOAT, `flux_err_sigma_subaru_y` FLOAT, `flux_err_realization_subaru_y` FLOAT, `flux_t_subaru_y` FLOAT, `flux_el_t_subaru_y` FLOAT, `flux_nl_t_subaru_z` FLOAT, `flux_nl_el_t_subaru_z` FLOAT, `flux_err_sigma_subaru_z` FLOAT, `flux_err_realization_subaru_z` FLOAT, `flux_t_subaru_z` FLOAT, `flux_el_t_subaru_z` FLOAT, `flux_nl_t_vista_h` FLOAT, `flux_nl_el_t_vista_h` FLOAT, `flux_err_sigma_vista_h` FLOAT, `flux_err_realization_vista_h` FLOAT, `flux_t_vista_h` FLOAT, `flux_el_t_vista_h` FLOAT, `flux_nl_t_vista_j` FLOAT, `flux_nl_el_t_vista_j` FLOAT, `flux_err_sigma_vista_j` FLOAT, `flux_err_realization_vista_j` FLOAT, `flux_t_vista_j` FLOAT, `flux_el_t_vista_j` FLOAT, `flux_nl_t_vista_ks` FLOAT, `flux_nl_el_t_vista_ks` FLOAT, `flux_err_sigma_vista_ks` FLOAT, `flux_err_realization_vista_ks` FLOAT, `flux_t_vista_ks` FLOAT, `flux_el_t_vista_ks` FLOAT, `flux_nl_t_vista_y` FLOAT, `flux_nl_el_t_vista_y` FLOAT, `flux_err_sigma_vista_y` FLOAT, `flux_err_realization_vista_y` FLOAT, `flux_t_vista_y` FLOAT, `flux_el_t_vista_y` FLOAT, `flux_nl_t_wircam_h` FLOAT, `flux_nl_el_t_wircam_h` FLOAT, `flux_err_sigma_wircam_h` FLOAT, `flux_err_realization_wircam_h` FLOAT, `flux_t_wircam_h` FLOAT, `flux_el_t_wircam_h` FLOAT, `flux_nl_t_wircam_ks` FLOAT, `flux_nl_el_t_wircam_ks` FLOAT, `flux_err_sigma_wircam_ks` FLOAT, `flux_err_realization_wircam_ks` FLOAT, `flux_t_wircam_ks` FLOAT, `flux_el_t_wircam_ks` FLOAT
) CLUSTERED BY (
halo_id, galaxy_id)
INTO 64 BUCKETS ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
This is the insert overwrtite command:
INSERT OVERWRITE TABLE cosmohub.pau_flagship_1_8_4_v0_3_c
SELECT
`halo_id`,
`galaxy_id` ,
`ra_gal`,
`dec_gal`,
`sed_cosmos`,
`ext_curve_cosmos` ,
`ebv_cosmos`,
`true_redshift_gal`,
`observed_redshift_gal`,
`abs_mag_r01_evolved`,
`logf_halpha_ext`,
`logf_hbeta_ext`,
`logf_o2_ext`,
`logf_n2_ext`,
`logf_o3_ext`,
`logf_s2_ext`,
`flux_nl_t_blanco_decam_g`,
`flux_nl_el_t_blanco_decam_g`,
`flux_err_sigma_blanco_decam_g`,
`flux_err_realization_blanco_decam_g`,
`flux_t_blanco_decam_g`,
`flux_el_t_blanco_decam_g`,
`flux_nl_t_blanco_decam_i`,
`flux_nl_el_t_blanco_decam_i`,
`flux_err_sigma_blanco_decam_i`,
`flux_err_realization_blanco_decam_i`,
`flux_t_blanco_decam_i`,
`flux_el_t_blanco_decam_i`,
`flux_nl_t_blanco_decam_r`,
`flux_nl_el_t_blanco_decam_r`,
`flux_err_sigma_blanco_decam_r`,
`flux_err_realization_blanco_decam_r`,
`flux_t_blanco_decam_r`,
`flux_el_t_blanco_decam_r`,
`flux_nl_t_blanco_decam_z`,
`flux_nl_el_t_blanco_decam_z`,
`flux_err_sigma_blanco_decam_z`,
`flux_err_realization_blanco_decam_z`,
`flux_t_blanco_decam_z`,
`flux_el_t_blanco_decam_z`,
`flux_nl_t_cfht_megacam_g_1`,
`flux_nl_el_t_cfht_megacam_g_1`,
`flux_err_sigma_cfht_megacam_g_1`,
`flux_err_realization_cfht_megacam_g_1`,
`flux_t_cfht_megacam_g_1`,
`flux_el_t_cfht_megacam_g_1`,
`flux_nl_t_cfht_megacam_i_1`,
`flux_nl_el_t_cfht_megacam_i_1`,
`flux_err_sigma_cfht_megacam_i_1`,
`flux_err_realization_cfht_megacam_i_1`,
`flux_t_cfht_megacam_i_1`,
`flux_el_t_cfht_megacam_i_1`,
`flux_nl_t_cfht_megacam_r_1`,
`flux_nl_el_t_cfht_megacam_r_1`,
`flux_err_sigma_cfht_megacam_r_1`,
`flux_err_realization_cfht_megacam_r_1`,
`flux_t_cfht_megacam_r_1`,
`flux_el_t_cfht_megacam_r_1`,
`flux_nl_t_cfht_megacam_u_1`,
`flux_nl_el_t_cfht_megacam_u_1`,
`flux_err_sigma_cfht_megacam_u_1`,
`flux_err_realization_cfht_megacam_u_1`,
`flux_t_cfht_megacam_u_1`,
`flux_el_t_cfht_megacam_u_1`,
`flux_nl_t_cfht_megacam_z_1`,
`flux_nl_el_t_cfht_megacam_z_1`,
`flux_err_sigma_cfht_megacam_z_1`,
`flux_err_realization_cfht_megacam_z_1`,
`flux_t_cfht_megacam_z_1`,
`flux_el_t_cfht_megacam_z_1`,
`flux_nl_t_cfht_u`,
`flux_nl_el_t_cfht_u`,
`flux_err_sigma_cfht_u`,
`flux_err_realization_cfht_u`,
`flux_t_cfht_u`,
`flux_el_t_cfht_u`,
`flux_nl_t_euclid_nisp_h`,
`flux_nl_el_t_euclid_nisp_h`,
`flux_err_sigma_euclid_nisp_h`,
`flux_err_realization_euclid_nisp_h`,
`flux_t_euclid_nisp_h`,
`flux_el_t_euclid_nisp_h`,
`flux_nl_t_euclid_nisp_j`,
`flux_nl_el_t_euclid_nisp_j`,
`flux_err_sigma_euclid_nisp_j`,
`flux_err_realization_euclid_nisp_j`,
`flux_t_euclid_nisp_j`,
`flux_el_t_euclid_nisp_j`,
`flux_nl_t_euclid_nisp_y`,
`flux_nl_el_t_euclid_nisp_y`,
`flux_err_sigma_euclid_nisp_y`,
`flux_err_realization_euclid_nisp_y`,
`flux_t_euclid_nisp_y`,
`flux_el_t_euclid_nisp_y`,
`flux_nl_t_euclid_vis`,
`flux_nl_el_t_euclid_vis`,
`flux_err_sigma_euclid_vis`,
`flux_err_realization_euclid_vis`,
`flux_t_euclid_vis`,
`flux_el_t_euclid_vis`,
`flux_nl_t_galex_nuv`,
`flux_nl_el_t_galex_nuv`,
`flux_err_sigma_galex_nuv`,
`flux_err_realization_galex_nuv`,
`flux_t_galex_nuv`,
`flux_el_t_galex_nuv`,
`flux_nl_t_pau_g`,
`flux_nl_el_t_pau_g`,
`flux_err_sigma_pau_g`,
`flux_err_realization_pau_g`,
`flux_t_pau_g`,
`flux_el_t_pau_g`,
`flux_nl_t_pau_i`,
`flux_nl_el_t_pau_i`,
`flux_err_sigma_pau_i`,
`flux_err_realization_pau_i`,
`flux_t_pau_i`,
`flux_el_t_pau_i`,
`flux_nl_t_pau_nb455`,
`flux_nl_el_t_pau_nb455`,
`flux_err_sigma_pau_nb455`,
`flux_err_realization_pau_nb455`,
`flux_t_pau_nb455`,
`flux_el_t_pau_nb455`,
`flux_nl_t_pau_nb465`,
`flux_nl_el_t_pau_nb465`,
`flux_err_sigma_pau_nb465`,
`flux_err_realization_pau_nb465`,
`flux_t_pau_nb465`,
`flux_el_t_pau_nb465`,
`flux_nl_t_pau_nb475`,
`flux_nl_el_t_pau_nb475`,
`flux_err_sigma_pau_nb475`,
`flux_err_realization_pau_nb475`,
`flux_t_pau_nb475`,
`flux_el_t_pau_nb475`,
`flux_nl_t_pau_nb485`,
`flux_nl_el_t_pau_nb485`,
`flux_err_sigma_pau_nb485`,
`flux_err_realization_pau_nb485`,
`flux_t_pau_nb485`,
`flux_el_t_pau_nb485`,
`flux_nl_t_pau_nb495`,
`flux_nl_el_t_pau_nb495`,
`flux_err_sigma_pau_nb495`,
`flux_err_realization_pau_nb495`,
`flux_t_pau_nb495`,
`flux_el_t_pau_nb495`,
`flux_nl_t_pau_nb505`,
`flux_nl_el_t_pau_nb505`,
`flux_err_sigma_pau_nb505`,
`flux_err_realization_pau_nb505`,
`flux_t_pau_nb505`,
`flux_el_t_pau_nb505`,
`flux_nl_t_pau_nb515`,
`flux_nl_el_t_pau_nb515`,
`flux_err_sigma_pau_nb515`,
`flux_err_realization_pau_nb515`,
`flux_t_pau_nb515`,
`flux_el_t_pau_nb515`,
`flux_nl_t_pau_nb525`,
`flux_nl_el_t_pau_nb525`,
`flux_err_sigma_pau_nb525`,
`flux_err_realization_pau_nb525`,
`flux_t_pau_nb525`,
`flux_el_t_pau_nb525`,
`flux_nl_t_pau_nb535`,
`flux_nl_el_t_pau_nb535`,
`flux_err_sigma_pau_nb535`,
`flux_err_realization_pau_nb535`,
`flux_t_pau_nb535`,
`flux_el_t_pau_nb535`,
`flux_nl_t_pau_nb545`,
`flux_nl_el_t_pau_nb545`,
`flux_err_sigma_pau_nb545`,
`flux_err_realization_pau_nb545`,
`flux_t_pau_nb545`,
`flux_el_t_pau_nb545`,
`flux_nl_t_pau_nb555`,
`flux_nl_el_t_pau_nb555`,
`flux_err_sigma_pau_nb555`,
`flux_err_realization_pau_nb555`,
`flux_t_pau_nb555`,
`flux_el_t_pau_nb555`,
`flux_nl_t_pau_nb565`,
`flux_nl_el_t_pau_nb565`,
`flux_err_sigma_pau_nb565`,
`flux_err_realization_pau_nb565`,
`flux_t_pau_nb565`,
`flux_el_t_pau_nb565`,
`flux_nl_t_pau_nb575`,
`flux_nl_el_t_pau_nb575`,
`flux_err_sigma_pau_nb575`,
`flux_err_realization_pau_nb575`,
`flux_t_pau_nb575`,
`flux_el_t_pau_nb575`,
`flux_nl_t_pau_nb585`,
`flux_nl_el_t_pau_nb585`,
`flux_err_sigma_pau_nb585`,
`flux_err_realization_pau_nb585`,
`flux_t_pau_nb585`,
`flux_el_t_pau_nb585`,
`flux_nl_t_pau_nb595`,
`flux_nl_el_t_pau_nb595`,
`flux_err_sigma_pau_nb595`,
`flux_err_realization_pau_nb595`,
`flux_t_pau_nb595`,
`flux_el_t_pau_nb595`,
`flux_nl_t_pau_nb605`,
`flux_nl_el_t_pau_nb605`,
`flux_err_sigma_pau_nb605`,
`flux_err_realization_pau_nb605`,
`flux_t_pau_nb605`,
`flux_el_t_pau_nb605`,
`flux_nl_t_pau_nb615`,
`flux_nl_el_t_pau_nb615`,
`flux_err_sigma_pau_nb615`,
`flux_err_realization_pau_nb615`,
`flux_t_pau_nb615`,
`flux_el_t_pau_nb615`,
`flux_nl_t_pau_nb625`,
`flux_nl_el_t_pau_nb625`,
`flux_err_sigma_pau_nb625`,
`flux_err_realization_pau_nb625`,
`flux_t_pau_nb625`,
`flux_el_t_pau_nb625`,
`flux_nl_t_pau_nb635`,
`flux_nl_el_t_pau_nb635`,
`flux_err_sigma_pau_nb635`,
`flux_err_realization_pau_nb635`,
`flux_t_pau_nb635`,
`flux_el_t_pau_nb635`,
`flux_nl_t_pau_nb645`,
`flux_nl_el_t_pau_nb645`,
`flux_err_sigma_pau_nb645`,
`flux_err_realization_pau_nb645`,
`flux_t_pau_nb645`,
`flux_el_t_pau_nb645`,
`flux_nl_t_pau_nb655`,
`flux_nl_el_t_pau_nb655`,
`flux_err_sigma_pau_nb655`,
`flux_err_realization_pau_nb655`,
`flux_t_pau_nb655`,
`flux_el_t_pau_nb655`,
`flux_nl_t_pau_nb665`,
`flux_nl_el_t_pau_nb665`,
`flux_err_sigma_pau_nb665`,
`flux_err_realization_pau_nb665`,
`flux_t_pau_nb665`,
`flux_el_t_pau_nb665`,
`flux_nl_t_pau_nb675`,
`flux_nl_el_t_pau_nb675`,
`flux_err_sigma_pau_nb675`,
`flux_err_realization_pau_nb675`,
`flux_t_pau_nb675`,
`flux_el_t_pau_nb675`,
`flux_nl_t_pau_nb685`,
`flux_nl_el_t_pau_nb685`,
`flux_err_sigma_pau_nb685`,
`flux_err_realization_pau_nb685`,
`flux_t_pau_nb685`,
`flux_el_t_pau_nb685`,
`flux_nl_t_pau_nb695`,
`flux_nl_el_t_pau_nb695`,
`flux_err_sigma_pau_nb695`,
`flux_err_realization_pau_nb695`,
`flux_t_pau_nb695`,
`flux_el_t_pau_nb695`,
`flux_nl_t_pau_nb705`,
`flux_nl_el_t_pau_nb705`,
`flux_err_sigma_pau_nb705`,
`flux_err_realization_pau_nb705`,
`flux_t_pau_nb705`,
`flux_el_t_pau_nb705`,
`flux_nl_t_pau_nb715`,
`flux_nl_el_t_pau_nb715`,
`flux_err_sigma_pau_nb715`,
`flux_err_realization_pau_nb715`,
`flux_t_pau_nb715`,
`flux_el_t_pau_nb715`,
`flux_nl_t_pau_nb725`,
`flux_nl_el_t_pau_nb725`,
`flux_err_sigma_pau_nb725`,
`flux_err_realization_pau_nb725`,
`flux_t_pau_nb725`,
`flux_el_t_pau_nb725`,
`flux_nl_t_pau_nb735`,
`flux_nl_el_t_pau_nb735`,
`flux_err_sigma_pau_nb735`,
`flux_err_realization_pau_nb735`,
`flux_t_pau_nb735`,
`flux_el_t_pau_nb735`,
`flux_nl_t_pau_nb745`,
`flux_nl_el_t_pau_nb745`,
`flux_err_sigma_pau_nb745`,
`flux_err_realization_pau_nb745`,
`flux_t_pau_nb745`,
`flux_el_t_pau_nb745`,
`flux_nl_t_pau_nb755`,
`flux_nl_el_t_pau_nb755`,
`flux_err_sigma_pau_nb755`,
`flux_err_realization_pau_nb755`,
`flux_t_pau_nb755`,
`flux_el_t_pau_nb755`,
`flux_nl_t_pau_nb765`,
`flux_nl_el_t_pau_nb765`,
`flux_err_sigma_pau_nb765`,
`flux_err_realization_pau_nb765`,
`flux_t_pau_nb765`,
`flux_el_t_pau_nb765`,
`flux_nl_t_pau_nb775`,
`flux_nl_el_t_pau_nb775`,
`flux_err_sigma_pau_nb775`,
`flux_err_realization_pau_nb775`,
`flux_t_pau_nb775`,
`flux_el_t_pau_nb775`,
`flux_nl_t_pau_nb785`,
`flux_nl_el_t_pau_nb785`,
`flux_err_sigma_pau_nb785`,
`flux_err_realization_pau_nb785`,
`flux_t_pau_nb785`,
`flux_el_t_pau_nb785`,
`flux_nl_t_pau_nb795`,
`flux_nl_el_t_pau_nb795`,
`flux_err_sigma_pau_nb795`,
`flux_err_realization_pau_nb795`,
`flux_t_pau_nb795`,
`flux_el_t_pau_nb795`,
`flux_nl_t_pau_nb805`,
`flux_nl_el_t_pau_nb805`,
`flux_err_sigma_pau_nb805`,
`flux_err_realization_pau_nb805`,
`flux_t_pau_nb805`,
`flux_el_t_pau_nb805`,
`flux_nl_t_pau_nb815`,
`flux_nl_el_t_pau_nb815`,
`flux_err_sigma_pau_nb815`,
`flux_err_realization_pau_nb815`,
`flux_t_pau_nb815`,
`flux_el_t_pau_nb815`,
`flux_nl_t_pau_nb825`,
`flux_nl_el_t_pau_nb825`,
`flux_err_sigma_pau_nb825`,
`flux_err_realization_pau_nb825`,
`flux_t_pau_nb825`,
`flux_el_t_pau_nb825`,
`flux_nl_t_pau_nb835`,
`flux_nl_el_t_pau_nb835`,
`flux_err_sigma_pau_nb835`,
`flux_err_realization_pau_nb835`,
`flux_t_pau_nb835`,
`flux_el_t_pau_nb835`,
`flux_nl_t_pau_nb845`,
`flux_nl_el_t_pau_nb845`,
`flux_err_sigma_pau_nb845`,
`flux_err_realization_pau_nb845`,
`flux_t_pau_nb845`,
`flux_el_t_pau_nb845`,
`flux_nl_t_pau_r`,
`flux_nl_el_t_pau_r`,
`flux_err_sigma_pau_r`,
`flux_err_realization_pau_r`,
`flux_t_pau_r`,
`flux_el_t_pau_r`,
`flux_nl_t_pau_u`,
`flux_nl_el_t_pau_u`,
`flux_err_sigma_pau_u`,
`flux_err_realization_pau_u`,
`flux_t_pau_u`,
`flux_el_t_pau_u`,
`flux_nl_t_pau_y`,
`flux_nl_el_t_pau_y`,
`flux_err_sigma_pau_y`,
`flux_err_realization_pau_y`,
`flux_t_pau_y`,
`flux_el_t_pau_y`,
`flux_nl_t_pau_z`,
`flux_nl_el_t_pau_z`,
`flux_err_sigma_pau_z`,
`flux_err_realization_pau_z`,
`flux_t_pau_z`,
`flux_el_t_pau_z`,
`flux_nl_t_sdss_g`,
`flux_nl_el_t_sdss_g`,
`flux_err_sigma_sdss_g`,
`flux_err_realization_sdss_g`,
`flux_t_sdss_g`,
`flux_el_t_sdss_g`,
`flux_nl_t_sdss_i`,
`flux_nl_el_t_sdss_i`,
`flux_err_sigma_sdss_i`,
`flux_err_realization_sdss_i`,
`flux_t_sdss_i`,
`flux_el_t_sdss_i`,
`flux_nl_t_sdss_r`,
`flux_nl_el_t_sdss_r`,
`flux_err_sigma_sdss_r`,
`flux_err_realization_sdss_r`,
`flux_t_sdss_r`,
`flux_el_t_sdss_r`,
`flux_nl_t_sdss_u`,
`flux_nl_el_t_sdss_u`,
`flux_err_sigma_sdss_u`,
`flux_err_realization_sdss_u`,
`flux_t_sdss_u`,
`flux_el_t_sdss_u`,
`flux_nl_t_sdss_z`,
`flux_nl_el_t_sdss_z`,
`flux_err_sigma_sdss_z`,
`flux_err_realization_sdss_z`,
`flux_t_sdss_z`,
`flux_el_t_sdss_z`,
`flux_nl_t_subaru_b`,
`flux_nl_el_t_subaru_b`,
`flux_err_sigma_subaru_b`,
`flux_err_realization_subaru_b`,
`flux_t_subaru_b`,
`flux_el_t_subaru_b`,
`flux_nl_t_subaru_i`,
`flux_nl_el_t_subaru_i`,
`flux_err_sigma_subaru_i`,
`flux_err_realization_subaru_i`,
`flux_t_subaru_i`,
`flux_el_t_subaru_i`,
`flux_nl_t_subaru_ia427`,
`flux_nl_el_t_subaru_ia427`,
`flux_err_sigma_subaru_ia427`,
`flux_err_realization_subaru_ia427`,
`flux_t_subaru_ia427`,
`flux_el_t_subaru_ia427`,
`flux_nl_t_subaru_ia464`,
`flux_nl_el_t_subaru_ia464`,
`flux_err_sigma_subaru_ia464`,
`flux_err_realization_subaru_ia464`,
`flux_t_subaru_ia464`,
`flux_el_t_subaru_ia464`,
`flux_nl_t_subaru_ia484`,
`flux_nl_el_t_subaru_ia484`,
`flux_err_sigma_subaru_ia484`,
`flux_err_realization_subaru_ia484`,
`flux_t_subaru_ia484`,
`flux_el_t_subaru_ia484`,
`flux_nl_t_subaru_ia505`,
`flux_nl_el_t_subaru_ia505`,
`flux_err_sigma_subaru_ia505`,
`flux_err_realization_subaru_ia505`,
`flux_t_subaru_ia505`,
`flux_el_t_subaru_ia505`,
`flux_nl_t_subaru_ia527`,
`flux_nl_el_t_subaru_ia527`,
`flux_err_sigma_subaru_ia527`,
`flux_err_realization_subaru_ia527`,
`flux_t_subaru_ia527`,
`flux_el_t_subaru_ia527`,
`flux_nl_t_subaru_ia574`,
`flux_nl_el_t_subaru_ia574`,
`flux_err_sigma_subaru_ia574`,
`flux_err_realization_subaru_ia574`,
`flux_t_subaru_ia574`,
`flux_el_t_subaru_ia574`,
`flux_nl_t_subaru_ia624`,
`flux_nl_el_t_subaru_ia624`,
`flux_err_sigma_subaru_ia624`,
`flux_err_realization_subaru_ia624`,
`flux_t_subaru_ia624`,
`flux_el_t_subaru_ia624`,
`flux_nl_t_subaru_ia679`,
`flux_nl_el_t_subaru_ia679`,
`flux_err_sigma_subaru_ia679`,
`flux_err_realization_subaru_ia679`,
`flux_t_subaru_ia679`,
`flux_el_t_subaru_ia679`,
`flux_nl_t_subaru_ia709`,
`flux_nl_el_t_subaru_ia709`,
`flux_err_sigma_subaru_ia709`,
`flux_err_realization_subaru_ia709`,
`flux_t_subaru_ia709`,
`flux_el_t_subaru_ia709`,
`flux_nl_t_subaru_ia738`,
`flux_nl_el_t_subaru_ia738`,
`flux_err_sigma_subaru_ia738`,
`flux_err_realization_subaru_ia738`,
`flux_t_subaru_ia738`,
`flux_el_t_subaru_ia738`,
`flux_nl_t_subaru_ia767`,
`flux_nl_el_t_subaru_ia767`,
`flux_err_sigma_subaru_ia767`,
`flux_err_realization_subaru_ia767`,
`flux_t_subaru_ia767`,
`flux_el_t_subaru_ia767`,
`flux_nl_t_subaru_ia827`,
`flux_nl_el_t_subaru_ia827`,
`flux_err_sigma_subaru_ia827`,
`flux_err_realization_subaru_ia827`,
`flux_t_subaru_ia827`,
`flux_el_t_subaru_ia827`,
`flux_nl_t_subaru_nb711`,
`flux_nl_el_t_subaru_nb711`,
`flux_err_sigma_subaru_nb711`,
`flux_err_realization_subaru_nb711`,
`flux_t_subaru_nb711`,
`flux_el_t_subaru_nb711`,
`flux_nl_t_subaru_nb816`,
`flux_nl_el_t_subaru_nb816`,
`flux_err_sigma_subaru_nb816`,
`flux_err_realization_subaru_nb816`,
`flux_t_subaru_nb816`,
`flux_el_t_subaru_nb816`,
`flux_nl_t_subaru_r`,
`flux_nl_el_t_subaru_r`,
`flux_err_sigma_subaru_r`,
`flux_err_realization_subaru_r`,
`flux_t_subaru_r`,
`flux_el_t_subaru_r`,
`flux_nl_t_subaru_v`,
`flux_nl_el_t_subaru_v`,
`flux_err_sigma_subaru_v`,
`flux_err_realization_subaru_v`,
`flux_t_subaru_v`,
`flux_el_t_subaru_v`,
`flux_nl_t_subaru_y`,
`flux_nl_el_t_subaru_y`,
`flux_err_sigma_subaru_y`,
`flux_err_realization_subaru_y`,
`flux_t_subaru_y`,
`flux_el_t_subaru_y`,
`flux_nl_t_subaru_z`,
`flux_nl_el_t_subaru_z`,
`flux_err_sigma_subaru_z`,
`flux_err_realization_subaru_z`,
`flux_t_subaru_z`,
`flux_el_t_subaru_z`,
`flux_nl_t_vista_h`,
`flux_nl_el_t_vista_h`,
`flux_err_sigma_vista_h`,
`flux_err_realization_vista_h`,
`flux_t_vista_h`,
`flux_el_t_vista_h`,
`flux_nl_t_vista_j`,
`flux_nl_el_t_vista_j`,
`flux_err_sigma_vista_j`,
`flux_err_realization_vista_j`,
`flux_t_vista_j`,
`flux_el_t_vista_j`,
`flux_nl_t_vista_ks`,
`flux_nl_el_t_vista_ks`,
`flux_err_sigma_vista_ks`,
`flux_err_realization_vista_ks`,
`flux_t_vista_ks`,
`flux_el_t_vista_ks`,
`flux_nl_t_vista_y`,
`flux_nl_el_t_vista_y`,
`flux_err_sigma_vista_y`,
`flux_err_realization_vista_y`,
`flux_t_vista_y`,
`flux_el_t_vista_y`,
`flux_nl_t_wircam_h`,
`flux_nl_el_t_wircam_h`,
`flux_err_sigma_wircam_h`,
`flux_err_realization_wircam_h`,
`flux_t_wircam_h`,
`flux_el_t_wircam_h`,
`flux_nl_t_wircam_ks`,
`flux_nl_el_t_wircam_ks`,
`flux_err_sigma_wircam_ks`,
`flux_err_realization_wircam_ks`,
`flux_t_wircam_ks`,
`flux_el_t_wircam_ks`
FROM jcarrete.pau_flagship_1_8_4_v0_3_pq;
An example query:
SELECT `flux_nl_t_pau_nb455`, `flux_nl_el_t_pau_nb455`, `flux_err_sigma_pau_nb455`, `flux_err_realization_pau_nb455`, `flux_el_t_pau_nb455`, `flux_t_pau_nb455` FROM cosmohub.pau_flagship_1_8_4_v0_3_c LIMIT 10;
Compute statistics:
ANALYZE TABLE cosmohub.pau_flagship_1_8_4_v0_3_c COMPUTE STATISTICS FOR COLUMNS;