来自Google BigQuery中'list_tables'的奇怪行为 [英] Weird behavior with from 'list_tables' in Google BigQuery

问题描述

这个问题稍有后续：表格一致性Google BigQuery？

在这里，调用 list_tables 会返回不同的结果 - 有时是5，有时是6。其他进程正在访问这个数据集（甚至这个项目），尽管表最近已被删除。在用户界面中，显示了5张表。

这怎么会发生？在表被删除后是否真的一致？

 （Pdb ++）print（list（table.name for table in dataset。 list_tables（max_results = 1000）））
 [u'test_table_195113'，u'test_table_433234'，u'test_table_459339'，u'test_table_509209'，u'test_table_715557'] 
（Pdb ++）print（list .name）for dataset.list_tables（max_results = 1000）））
 [u'test_table_433234'，u'test_table_459339'，u'test_table_491589'，u'test_table_509209'，u'test_table_71989'，u'test_table_809169'] 
（Pdb ++）print（list（table.name for table in dataset.list_tables（max_results = 1000）））
 [u'test_table_433234'，u'test_table_459339'，u'test_table_491589'，u'test_table_509209 '，'u'test_table_71989'，u'test_table_809169'] 
（Pdb ++）print（list（table.name for table in dataset.list_tables（max_results = 1000）））
 [u'test_table_195113'，u 'test_table_433234'，u'test_table_459339'，u'test_table_509209' ，u'test_table_715557'] 
  

解决方案

现在应该解决。你可否确认？

需要说明的是，表格列表的一致性并不能保证。在实践中，这个不一致的时期应该很短，但周三有一个问题导致用户体验到最终一致性的陈旧程度增加，但现在应该解决。

Somewhat follow-on from this question: Table consistency in Google BigQuery?

Here, calling list_tables returns different results - sometimes 5, sometimes 6. No other processes are accessing this dataset (or even this project), though tables have recently been deleted. In the UI, 5 tables are shown.

How could this happen? Is there really consistency after a table has been deleted?

(Pdb++) print(list(table.name for table in dataset.list_tables(max_results=1000)))
[u'test_table_195113', u'test_table_433234', u'test_table_459339', u'test_table_509209', u'test_table_715557']
(Pdb++) print(list(table.name for table in dataset.list_tables(max_results=1000)))
[u'test_table_433234', u'test_table_459339', u'test_table_491589', u'test_table_509209', u'test_table_71989', u'test_table_809169']
(Pdb++) print(list(table.name for table in dataset.list_tables(max_results=1000)))
[u'test_table_433234', u'test_table_459339', u'test_table_491589', u'test_table_509209', u'test_table_71989', u'test_table_809169']
(Pdb++) print(list(table.name for table in dataset.list_tables(max_results=1000)))
[u'test_table_195113', u'test_table_433234', u'test_table_459339', u'test_table_509209', u'test_table_715557']

解决方案

This should be resolved now. Can you confirm?

Just to be clear, there is no guarantee on the consistency of table list. In practice, this period of inconsistency should be very short but there was an issue on Wednesday that caused users to experience an increase in staleness of the eventual consistency but it should now be resolved.

这篇关于来自Google BigQuery中'list_tables'的奇怪行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！