CODEWITHSUNDEEP
sqlgoogle-bigquerysql-function
MoShe
MoShe

Reputation: 6427

using function in google bigquery

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

Upvotes: 0

Views: 807

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172944

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]

Upvotes: 2

Related Questions