Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
sql.presto.kafka.count_column_100.sql Maven / Gradle / Ivy
select
count(c_bigint_1), count(c_double_1), count(c_varchar_1),
count(c_bigint_2), count(c_double_2), count(c_varchar_2),
count(c_bigint_3), count(c_double_3), count(c_varchar_3),
count(c_bigint_4), count(c_double_4), count(c_varchar_4),
count(c_bigint_5), count(c_double_5), count(c_varchar_5),
count(c_bigint_6), count(c_double_6), count(c_varchar_6),
count(c_bigint_7), count(c_double_7), count(c_varchar_7),
count(c_bigint_8), count(c_double_8), count(c_varchar_8),
count(c_bigint_9), count(c_double_9), count(c_varchar_9),
count(c_bigint_10), count(c_double_10), count(c_varchar_10),
count(c_bigint_11), count(c_double_11), count(c_varchar_11),
count(c_bigint_12), count(c_double_12), count(c_varchar_12),
count(c_bigint_13), count(c_double_13), count(c_varchar_13),
count(c_bigint_14), count(c_double_14), count(c_varchar_14),
count(c_bigint_15), count(c_double_15), count(c_varchar_15),
count(c_bigint_16), count(c_double_16), count(c_varchar_16),
count(c_bigint_17), count(c_double_17), count(c_varchar_17),
count(c_bigint_18), count(c_double_18), count(c_varchar_18),
count(c_bigint_19), count(c_double_19), count(c_varchar_19),
count(c_bigint_20), count(c_double_20), count(c_varchar_20),
count(c_bigint_21), count(c_double_21), count(c_varchar_21),
count(c_bigint_22), count(c_double_22), count(c_varchar_22),
count(c_bigint_23), count(c_double_23), count(c_varchar_23),
count(c_bigint_24), count(c_double_24), count(c_varchar_24),
count(c_bigint_25), count(c_double_25), count(c_varchar_25),
count(c_bigint_26), count(c_double_26), count(c_varchar_26),
count(c_bigint_27), count(c_double_27), count(c_varchar_27),
count(c_bigint_28), count(c_double_28), count(c_varchar_28),
count(c_bigint_29), count(c_double_29), count(c_varchar_29),
count(c_bigint_30), count(c_double_30), count(c_varchar_30),
count(c_bigint_31), count(c_double_31), count(c_varchar_31),
count(c_bigint_32), count(c_double_32), count(c_varchar_32),
count(c_bigint_33), count(c_double_33), count(c_varchar_33),
count(c_bigint_34), count(c_double_34), count(c_varchar_34),
count(c_bigint_35), count(c_double_35), count(c_varchar_35),
count(c_bigint_36), count(c_double_36), count(c_varchar_36),
count(c_bigint_37), count(c_double_37), count(c_varchar_37),
count(c_bigint_38), count(c_double_38), count(c_varchar_38),
count(c_bigint_39), count(c_double_39), count(c_varchar_39),
count(c_bigint_40), count(c_double_40), count(c_varchar_40),
count(c_bigint_41), count(c_double_41), count(c_varchar_41),
count(c_bigint_42), count(c_double_42), count(c_varchar_42),
count(c_bigint_43), count(c_double_43), count(c_varchar_43),
count(c_bigint_44), count(c_double_44), count(c_varchar_44),
count(c_bigint_45), count(c_double_45), count(c_varchar_45),
count(c_bigint_46), count(c_double_46), count(c_varchar_46),
count(c_bigint_47), count(c_double_47), count(c_varchar_47),
count(c_bigint_48), count(c_double_48), count(c_varchar_48),
count(c_bigint_49), count(c_double_49), count(c_varchar_49),
count(c_bigint_50), count(c_double_50), count(c_varchar_50),
count(c_bigint_51), count(c_double_51), count(c_varchar_51),
count(c_bigint_52), count(c_double_52), count(c_varchar_52),
count(c_bigint_53), count(c_double_53), count(c_varchar_53),
count(c_bigint_54), count(c_double_54), count(c_varchar_54),
count(c_bigint_55), count(c_double_55), count(c_varchar_55),
count(c_bigint_56), count(c_double_56), count(c_varchar_56),
count(c_bigint_57), count(c_double_57), count(c_varchar_57),
count(c_bigint_58), count(c_double_58), count(c_varchar_58),
count(c_bigint_59), count(c_double_59), count(c_varchar_59),
count(c_bigint_60), count(c_double_60), count(c_varchar_60),
count(c_bigint_61), count(c_double_61), count(c_varchar_61),
count(c_bigint_62), count(c_double_62), count(c_varchar_62),
count(c_bigint_63), count(c_double_63), count(c_varchar_63),
count(c_bigint_64), count(c_double_64), count(c_varchar_64),
count(c_bigint_65), count(c_double_65), count(c_varchar_65),
count(c_bigint_66), count(c_double_66), count(c_varchar_66),
count(c_bigint_67), count(c_double_67), count(c_varchar_67),
count(c_bigint_68), count(c_double_68), count(c_varchar_68),
count(c_bigint_69), count(c_double_69), count(c_varchar_69),
count(c_bigint_70), count(c_double_70), count(c_varchar_70),
count(c_bigint_71), count(c_double_71), count(c_varchar_71),
count(c_bigint_72), count(c_double_72), count(c_varchar_72),
count(c_bigint_73), count(c_double_73), count(c_varchar_73),
count(c_bigint_74), count(c_double_74), count(c_varchar_74),
count(c_bigint_75), count(c_double_75), count(c_varchar_75),
count(c_bigint_76), count(c_double_76), count(c_varchar_76),
count(c_bigint_77), count(c_double_77), count(c_varchar_77),
count(c_bigint_78), count(c_double_78), count(c_varchar_78),
count(c_bigint_79), count(c_double_79), count(c_varchar_79),
count(c_bigint_80), count(c_double_80), count(c_varchar_80),
count(c_bigint_81), count(c_double_81), count(c_varchar_81),
count(c_bigint_82), count(c_double_82), count(c_varchar_82),
count(c_bigint_83), count(c_double_83), count(c_varchar_83),
count(c_bigint_84), count(c_double_84), count(c_varchar_84),
count(c_bigint_85), count(c_double_85), count(c_varchar_85),
count(c_bigint_86), count(c_double_86), count(c_varchar_86),
count(c_bigint_87), count(c_double_87), count(c_varchar_87),
count(c_bigint_88), count(c_double_88), count(c_varchar_88),
count(c_bigint_89), count(c_double_89), count(c_varchar_89),
count(c_bigint_90), count(c_double_90), count(c_varchar_90),
count(c_bigint_91), count(c_double_91), count(c_varchar_91),
count(c_bigint_92), count(c_double_92), count(c_varchar_92),
count(c_bigint_93), count(c_double_93), count(c_varchar_93),
count(c_bigint_94), count(c_double_94), count(c_varchar_94),
count(c_bigint_95), count(c_double_95), count(c_varchar_95),
count(c_bigint_96), count(c_double_96), count(c_varchar_96),
count(c_bigint_97), count(c_double_97), count(c_varchar_97),
count(c_bigint_98), count(c_double_98), count(c_varchar_98),
count(c_bigint_99), count(c_double_99), count(c_varchar_99),
count(c_bigint_100), count(c_double_100), count(c_varchar_100)
from ${database}.${schema}.${table}
