using function in google bigquery

Question

I am trying to use sql function in my BigQuery query :

SELECT FORMAT("%T", NET.HOST(resolved_urls.url)) AS host, FROM [tableName] LIMIT 1000

But I get the following error:

Error: 2.15 - 2.55: Unrecognized function format

I am getting these error for every sql function i am trying to use.

Any Idea ? thank you

Mikhail Berlyant · Accepted Answer · 2016-12-20 18:35:03Z

2

Those new functions are supported by BigQuery Standard SQL only

Try below

#standardSQL
SELECT FORMAT("%T", NET.HOST(resolved_urls.url)) AS host, FROM tableName LIMIT 1000

Also note: in Standard SQL you use `tableName` and not [tableName]

answered Dec 20, 2016 at 18:35

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1