bigquery-examples

bigquery-examples copied to clipboard

Update instructions to clarify standard SQL versus legacy SQL

8

Hello, I'm new to BigQuery and trying to follow the examples, but all 3 examples fail. I do have access to the tables and can run simple count(*) queries on...

tomasramanauskas

Per https://cloud.google.com/bigquery/user-defined-functions

deflaux

There appears to be a bug in https://github.com/googlegenomics/bigquery-examples/blob/master/pgp/sql/gvcf_variants/allele-count.sql Specifically its not incrementing the alternate_allele_count when genotype 2 corresponds to the allele in question. Here's our result: ``` SELECT contig_name, start_pos,...

deflaux

Since "the same" variant can occur on multiple records in our tables (see example records shown by query below), it breaks the experiment we are trying to do with table...

deflaux

for an example see #13

deflaux

optimize all queries using FLATTEN

3

Restructure them so that the clause within the FLATTEN returns only the columns needed and also applies any applicable WHERE clauses.

deflaux

There are two forms of sequence identifier being used in different tables for the same sequence. The variant1kG table refers to chromosome 1 in field "contig" as "1", while the...

maxbox51