MAX_TOKEN_VAL error in bq command line

Question

I'm new to bq command line, trying to run a simple query that works in UI...

bq query “select Email_Address from Contact.mailchimp_unsubscribe”

I get this error:

Error in query string: Error processing job 'aaa-dataplatform:bqjob_r41894edbc8642323_00000161bebe6574_1': Encountered " "\u201c "" at line 1, column 1. Was expecting: < EOF >

If I change the column name Email_Address to * the query works. However, I will need to make this an append query with a specific column list. So, need to figure out how to make the column list work.

Answer 1

u201c is a left double quotation mark; error message also says that it's at the line 1, column 1. So the quotation mark is passed to BQ with the query text. In the command line, try using neutral double or single quotation.