Parameterized views return rows when given parameters

DB check2026-09-29 22:29 UTC · cbioportal_public_librechat_blue (ClickHouse 26.4.1) · read-only, max_threads=4

All 15 parameterized views on the public database return rows when called with parameters. One view, clinical_attribute_counts, was also queried without parameters, and that query failed with EMPTY_LIST_OF_COLUMNS_PASSED (below). The console itself wasn't observed, but this is the likely explanation for its “No records found”: a console preview of a parameterized view is a plain SELECT with no parameters, so it most likely hits the same error and shows it as an empty result. An empty preview therefore probably doesn't mean the view is empty or broken.

Without parameters (the one query tested)

SELECT count() FROM clinical_attribute_counts

Received exception from server (version 26.4.1):
Code: 90. DB::Exception: Received from <clickhouse-host>. DB::Exception: Empty list of columns passed. (EMPTY_LIST_OF_COLUMNS_PASSED)
(query: SELECT count() FROM clinical_attribute_counts)

With parameters

Each view queried with LIMIT 5; “rows returned” is the total without the limit. Aggregate counts only.

View	Rows returned	Query
`clinical_attribute_counts`	5	`SELECT * FROM clinical_attribute_counts(study='msk_chord_2024', attribute='CANCER_TYPE')`
`top_mutated_genes_in_study`	10	`SELECT * FROM top_mutated_genes_in_study(study='msk_chord_2024', top_n=10)`
`top_cna_genes_in_study`	10	`SELECT * FROM top_cna_genes_in_study(study='msk_chord_2024', top_n=10)`
`top_sv_genes_in_study`	10	`SELECT * FROM top_sv_genes_in_study(study='msk_chord_2024', top_n=10)`
`top_mutated_genes_in_cohort`	10	`SELECT * FROM top_mutated_genes_in_cohort(preference='all_studies_non_redundant', top_n=10)`
`gene_mutation_frequency_in_study`	5	`SELECT * FROM gene_mutation_frequency_in_study(study='msk_chord_2024', gene='TP53')`
`gene_mutation_frequency_in_studies`	5	`SELECT * FROM gene_mutation_frequency_in_studies(studies=['msk_chord_2024'], gene='TP53')`
`gene_mutation_frequency_by_cancer_type`	89	`SELECT * FROM gene_mutation_frequency_by_cancer_type(preference='all_studies_non_redundant', gene='TP53')`
`gene_alteration_frequency_by_cancer_type`	89	`SELECT * FROM gene_alteration_frequency_by_cancer_type(preference='all_studies_non_redundant', gene='TP53', alteration='mutation')`
`gene_cna_distribution_in_study`	5	`SELECT * FROM gene_cna_distribution_in_study(study='msk_chord_2024', gene='TP53')`
`gene_mutation_variants_in_study`	2,088	`SELECT * FROM gene_mutation_variants_in_study(study='msk_chord_2024', gene='TP53')`
`co_altered_genes_in_study`	10	`SELECT * FROM co_altered_genes_in_study(study='msk_chord_2024', gene='TP53', top_n=10)`
`gene_pair_coexpression`	1	`SELECT * FROM gene_pair_coexpression(study='brca_tcga_pan_can_atlas_2018', profile_type='rna_seq_v2_mrna', gene_a='TP53', gene_b='MDM2')`
`treatment_counts_in_study`	245	`SELECT * FROM treatment_counts_in_study(study='msk_chord_2024')`
`treatment_regimens_in_study`	1,147	`SELECT * FROM treatment_regimens_in_study(study='msk_chord_2024')`

`clinical_attribute_counts`

SELECT * FROM clinical_attribute_counts(study='msk_chord_2024', attribute='CANCER_TYPE') LIMIT 5

5 rows in total; first 5 shown.

value	count	pct_of_study	level
Prostate Cancer	3211	12.8	sample
Breast Cancer	5368	21.4	sample
Pancreatic Cancer	3109	12.4	sample
Colorectal Cancer	5543	22.1	sample
Non-Small Cell Lung Cancer	7809	31.2	sample

`top_mutated_genes_in_study`

SELECT * FROM top_mutated_genes_in_study(study='msk_chord_2024', top_n=10) LIMIT 5

10 rows in total; first 5 shown.

hugo_gene_symbol	altered_samples	profiled_samples	frequency_pct	total_mutation_events
TP53	13124	25040	52.4	13876
KRAS	7128	25040	28.5	7231
APC	4777	25040	19.1	7187
PIK3CA	3708	25040	14.8	4178
EGFR	2159	25040	8.6	2556

`top_cna_genes_in_study`

SELECT * FROM top_cna_genes_in_study(study='msk_chord_2024', top_n=10) LIMIT 5

10 rows in total; first 5 shown.

hugo_gene_symbol	cytoband	cna_type	altered_samples	profiled_samples	frequency_pct
CDKN2A	9p21.3	HOMDEL	1546	25040	6.2
MYC	8q24.21	AMP	1533	25040	6.1
CDKN2B	9p21.3	HOMDEL	1459	25040	5.8
CCND1	11q13.3	AMP	1263	25040	5
FGF19	11q13.3	AMP	1167	25040	4.7

`top_sv_genes_in_study`

SELECT * FROM top_sv_genes_in_study(study='msk_chord_2024', top_n=10) LIMIT 5

10 rows in total; first 5 shown.

hugo_gene_symbol	altered_samples	profiled_samples	frequency_pct	total_sv_events
TMPRSS2	897	25038	3.6	959
ERG	717	25040	2.9	722
ALK	246	25040	1	269
TP53	148	25040	0.6	148
RET	140	25040	0.6	167

`top_mutated_genes_in_cohort`

SELECT * FROM top_mutated_genes_in_cohort(preference='all_studies_non_redundant', top_n=10) LIMIT 5

10 rows in total; first 5 shown.

hugo_gene_symbol	altered_samples	profiled_samples	frequency_pct	total_mutation_events
TP53	47030	123828	38	51225
KRAS	14750	123813	11.9	15027
PIK3CA	13521	123829	10.9	15644
APC	10805	120375	9	15778
KMT2D	9695	115310	8.4	13348

`gene_mutation_frequency_in_study`

SELECT * FROM gene_mutation_frequency_in_study(study='msk_chord_2024', gene='TP53') LIMIT 5

5 rows in total; first 5 shown.

cancer_type	altered_samples	profiled_samples	frequency_pct
Prostate Cancer	837	3211	26.1
Breast Cancer	2138	5368	39.8
Pancreatic Cancer	2076	3109	66.8
Colorectal Cancer	4068	5543	73.4
Non-Small Cell Lung Cancer	4005	7809	51.3

`gene_mutation_frequency_in_studies`

SELECT * FROM gene_mutation_frequency_in_studies(studies=['msk_chord_2024'], gene='TP53') LIMIT 5

5 rows in total; first 5 shown.

cancer_type	altered_samples	profiled_samples	frequency_pct
Prostate Cancer	837	3211	26.1
Breast Cancer	2138	5368	39.8
Pancreatic Cancer	2076	3109	66.8
Colorectal Cancer	4068	5543	73.4
Non-Small Cell Lung Cancer	4005	7809	51.3

`gene_mutation_frequency_by_cancer_type`

SELECT * FROM gene_mutation_frequency_by_cancer_type(preference='all_studies_non_redundant', gene='TP53') LIMIT 5

89 rows in total; first 5 shown.

cancer_type	altered_samples	profiled_samples	frequency_pct
(empty)	7	50	14
Germ Cell Tumor	97	730	13.3
Gastric Cancer	533	866	61.5
CNS Cancer	4	229	1.7
Gastrointestinal Stromal Tumor	43	748	5.7

`gene_alteration_frequency_by_cancer_type`

SELECT * FROM gene_alteration_frequency_by_cancer_type(preference='all_studies_non_redundant', gene='TP53', alteration='mutation') LIMIT 5

89 rows in total; first 5 shown.

cancer_type	altered_samples	profiled_samples	frequency_pct
Bladder Cancer	1887	4044	46.7
Soft Tissue Sarcoma	2338	8945	26.1
Thymic Tumor	22	152	14.5
Miscellaneous Brain Tumor	5	58	8.6
Lung Cancer	33	64	51.6

`gene_cna_distribution_in_study`

SELECT * FROM gene_cna_distribution_in_study(study='msk_chord_2024', gene='TP53') LIMIT 5

5 rows in total; first 5 shown.

profile_type	cna_value	cna_label	samples	profiled_samples	pct_of_profiled
cna	2	Amplified	3	25034	0
cna	0	Diploid	24851	25034	99.3
cna	-1.5	Other	36	25034	0.1
cna	-2	Homozygously deleted	144	25034	0.6
cna	NA	NA	6	25034	NULL

`gene_mutation_variants_in_study`

SELECT * FROM gene_mutation_variants_in_study(study='msk_chord_2024', gene='TP53') LIMIT 5

2,088 rows in total; first 5 shown.

mutation_variant	mutation_type	altered_samples	profiled_samples	frequency_pct	total_mutation_events
R175H	Missense_Mutation	691	25040	2.8	691
R248Q	Missense_Mutation	390	25040	1.6	390
R273H	Missense_Mutation	368	25040	1.5	368
R273C	Missense_Mutation	361	25040	1.4	361
R282W	Missense_Mutation	351	25040	1.4	351

`co_altered_genes_in_study`

SELECT * FROM co_altered_genes_in_study(study='msk_chord_2024', gene='TP53', top_n=10) LIMIT 5

10 rows in total; first 5 shown.

hugo_gene_symbol	mutant_altered	mutant_profiled	mutant_pct	wildtype_altered	wildtype_profiled	wildtype_pct	pct_difference
APC	3450	13124	26.3	1327	11916	11.1	15.2
KRAS	4283	13124	32.6	2845	11916	23.9	8.7
CDKN2A	1097	13124	8.4	241	11916	2	6.4
PIK3CA	1555	13124	11.8	2153	11916	18.1	-6.3
GATA3	287	13124	2.2	814	11916	6.8	-4.6

`gene_pair_coexpression`

SELECT * FROM gene_pair_coexpression(study='brca_tcga_pan_can_atlas_2018', profile_type='rna_seq_v2_mrna', gene_a='TP53', gene_b='MDM2') LIMIT 5

1 row in total; first 1 shown.

gene_a	gene_b	profile_type	spearman_correlation	num_samples
TP53	MDM2	rna_seq_v2_mrna	-0.024754090416310826	1082

`treatment_counts_in_study`

SELECT * FROM treatment_counts_in_study(study='msk_chord_2024') LIMIT 5

245 rows in total; first 5 shown.

agent	treatment_types	treatment_subtypes	patients	treated_patients	pct_of_treated_patients
TOPOTECAN	[]	['Chemo']	21	21473	0.1
SELUMETINIB	[]	['Targeted']	1	21473	0
BICALUTAMIDE	[]	['Hormone']	1243	21473	5.8
TRASTUZUMAB	[]	['Biologic']	959	21473	4.5
CABAZITAXEL	[]	['Chemo']	338	21473	1.6

`treatment_regimens_in_study`

SELECT * FROM treatment_regimens_in_study(study='msk_chord_2024') LIMIT 5

1,147 rows in total; first 5 shown.

regimen	n_agents	patients	treated_patients
CARBOPLATIN + PEMBROLIZUMAB + PEMETREXED + ZOLEDRONIC ACID	4	9	21224
CAPECITABINE + LEUPROLIDE + ZOLEDRONIC ACID	3	1	21224
METHOTREXATE + TAMOXIFEN	2	2	21224
CABAZITAXEL + MEGESTROL	2	1	21224
CAPECITABINE + TRASTUZUMAB + TUCATINIB	3	3	21224