search

bigdatagenomics / bdg-formats

Open source formats for scalable genomic processing systems using Avro. Apache 2 licensed.
Apache License 2.0
38 stars 35 forks source link

Rename "end" fields #49

Closed kozanitis closed 9 years ago

kozanitis commented 9 years ago

I have trouble accessing those "end" fields (e.g. AlignmentRecord.end, variant.end) with sparkSql because end is a reserved keyword there and it conflicts with the field names.

I was wondering: Is it possible to assign different names to those fields?

fnothaft commented 9 years ago

Is there a way to escape the field names in Spark SQL? My preference would be against changing the end fields unless absolutely necessary.

kozanitis commented 9 years ago

No worries then... I just verified that you can escape column names using end (same convention as in HiveQL)

slagelwa commented 7 years ago

Encountered this myself recently, hence the reason we've been using "stop" instead of "end". "stop" also seems to go along with "start" just a little more IMHO. Really wish SQL reserved keywords were taken into consideration. Its a real pain to escape these in SQL statements...