#standardsql نتائج البحث
100,000 rows processed in 4 seconds (cc: @MylesBorins @SandeepDinesh @ElliottBrossard ) TODO: - await() for async->return in BigQuery #standardSQL
Let me BigQuery that for you... top repos that only use leading commas and top repos that allow them. (but if #standardSQL allowed trailing commas - like any modern language - I would be so happy - and the issue wouldn't be anymore)
たまたま分母が0になるデータがあったらしく、これまでの運用では問題なく回っていたクエリがエラーになってしまい、調べてみたらsafe_divideという関数があることを知り変更したところ解決しました。 これまでは運がよかっただけで、本来はこれを使っていたほうがいいのかな。TIL。 #standardSQL
#TiEInflect easy simple #standardsql change to get all of the Giants wins for all games played. Piece of cake!! Oh wow there is the Food Theme again @TiEInflect #AI and #MachineLearning Hands-on Bootcamp!! Must be time for snacks
Learn how to perform large scale mutations in #bigquery without exceeding your quota. Karthi Thyagarajan (@kthyagar) explains how with #standardSQL examples involving hypothetical #GDPR deletion and update requests. cloud.google.com/blog/big-data/…
Just added balances table to our Ethereum dataset in BigQuery: ``` #standardSQL select * from `bigquery-public-data.crypto_ethereum.balances` order by eth_balance desc limit 10 ``` Updated daily.
Turns out you can prefix queries with #standardsql Thanks for the tips @polleyg @dan_mcclary and @felipehoffa !
The new BQUI launched in beta. You can finally get rid of the #StandardSQL tag in front of your queries 🙂. This is just one of many improvements. Check it out (and give us lots of feedback pls). cloud.google.com/bigquery/docs/…
You can also just prefix all your SQL with "#standardSQL" instead.
If you prefix a query with #standardSQL it should override the default. There is also a Chrome extension which sets the default too: chrome.google.com/webstore/detai…
a) for many, that's a feature b) have you tried #standardSQL? is a game changer c) cloud.google.com/bigquery/partn…
Can Legacy SQL just die already? Whats the point?? Still so much documentation for it, despite it being basically useless. #standardsql #bigquery #legacysucks
They are all typos, I am sure! The issue with #StandardSQL is the standard part :-).
No need to learn a new language - TDengine supports standard SQL. Manage your cluster and query data with ease. #StandardSQL
Say goodbye to specialized training. TDengine's support for standard SQL reduces the learning curve, making it accessible to a wide range of users, from beginners to experts. #StandardSQL #UserFriendly
TDengine supports standard SQL as its query language, reducing the learning curve for your team. Data analysts and industry veterans can work with ease. #StandardSQL #UserFriendly
Big win for the #StandardSQL Committee... congratulations @pg_xocolatl
From an SQL syntax point of view each instance is a separate column constraint. The SQL standard does not prohibit multiple constraints that duplicate a restriction so yes, valid in #StandardSQL.
Day 67/100 Besides Google Cloud challenges not working, I learned to do a refresh through the ff: #standardSQL CREATE OR REPLACE VIEW (or TABLE) ecommerce.vw_latest_transactions AS SELECT ... #WomenWhoCode #WomenInScience #WomenInSTEM #SQL #DataAnalytics #100DaysOfCode
Logica - A logic programming language that compiles to StandardSQL and runs on Google BigQuery. buff.ly/3mW6fFh #Python #BigQuery #StandardSQL
Handy Date Manipulation Functions for #standardSQL linkedin.com/pulse/handy-da…
たまたま分母が0になるデータがあったらしく、これまでの運用では問題なく回っていたクエリがエラーになってしまい、調べてみたらsafe_divideという関数があることを知り変更したところ解決しました。 これまでは運がよかっただけで、本来はこれを使っていたほうがいいのかな。TIL。 #standardSQL
✔️ Unified analytics experience. Use #standardSQL and BQ's familiar UI to analyze data across Google Cloud, AWS, and Azure (coming soon)!
Let's move this to Stack Overflow? Happy to fix queries there :) (hint: it's #standardSQL now)
If you can't take the data to the model, just take the model to the data viralml.com/video-content.… #Standardsql #ViralML
Just added balances table to our Ethereum dataset in BigQuery: ``` #standardSQL select * from `bigquery-public-data.crypto_ethereum.balances` order by eth_balance desc limit 10 ``` Updated daily.
If you can't take the data to the model, just take the model to the data viralml.com/video-content.… #Standardsql #ViralML
#standardSQL select substr(input, 0, 10) as sighash, count(*) as count from `bigquery-public-data.crypto_ethereum.traces` where length(input) >= 10 group by sighash order by count desc limit 100
my #BigQuery #standardSQL tip of the day: if you ever want to count how many times a certain phrase appears in an array that actually happens to be stored as type STRING, this is the format to do so: ARRAY_LENGTH(SPLIT(columnName,"phrase"))-1 AS count_of_phrase 😏📊👍🏼
この本もっと早く読んでおけばよかったな。実務に使う基礎〜応用まで大体カバーされてる。#StandardSQL 勢のわたしとしてはポスグレ特有の関数はもはや10年戦えない感あるけど、それも発展的に取り込まれてるだろうし、本書で取り上げてるベースの部分の考え方は確かに10年戦えそう。あと丁寧で文字数
#standardsql のおかげで standard が書けるようになったので、そのうちかけなくなるかもしれない
たまたま分母が0になるデータがあったらしく、これまでの運用では問題なく回っていたクエリがエラーになってしまい、調べてみたらsafe_divideという関数があることを知り変更したところ解決しました。 これまでは運がよかっただけで、本来はこれを使っていたほうがいいのかな。TIL。 #standardSQL
100,000 rows processed in 4 seconds (cc: @MylesBorins @SandeepDinesh @ElliottBrossard ) TODO: - await() for async->return in BigQuery #standardSQL
Let me BigQuery that for you... top repos that only use leading commas and top repos that allow them. (but if #standardSQL allowed trailing commas - like any modern language - I would be so happy - and the issue wouldn't be anymore)
#TiEInflect easy simple #standardsql change to get all of the Giants wins for all games played. Piece of cake!! Oh wow there is the Food Theme again @TiEInflect #AI and #MachineLearning Hands-on Bootcamp!! Must be time for snacks
Something went wrong.
Something went wrong.
United States Trends
- 1. #WWERaw 10.7K posts
- 2. Cuomo 117K posts
- 3. Koa Peat N/A
- 4. Cowboys 29.8K posts
- 5. #OlandriaxCFDAAwards 6,756 posts
- 6. Monday Night Football 8,312 posts
- 7. Caleb Wilson N/A
- 8. Walt Weiss 2,731 posts
- 9. Harvey Weinstein 8,381 posts
- 10. Arizona 30.4K posts
- 11. Teen Vogue 4,837 posts
- 12. Braves 11.6K posts
- 13. Sliwa 33K posts
- 14. Schwab 5,757 posts
- 15. Hamburger Helper 2,802 posts
- 16. Diane Ladd 6,593 posts
- 17. Ben Shapiro 39.9K posts
- 18. Myles Turner 1,651 posts
- 19. Snit N/A
- 20. $PLTR 20.7K posts