Exemplos de Sampling.hashed em Python

Exemplo n.º 1

Arquivo: bq_sampling_tests.py Projeto: brecht-d-m/amma-bda

 def test_hashed_with_fields(self):
     expected_sql = 'SELECT f1 FROM (%s) WHERE ABS(HASH(f1)) %% 100 < 5' % TestCases.BASE_SQL
     self._apply_sampling(Sampling.hashed('f1', 5, fields=['f1']),
                          expected_sql)

Exemplo n.º 2

Arquivo: bq_sampling_tests.py Projeto: brecht-d-m/amma-bda

 def test_hashed_and_limited(self):
     expected_sql = 'SELECT * FROM (%s) WHERE ABS(HASH(f1)) %% 100 < 5 LIMIT 100' \
                    % TestCases.BASE_SQL
     self._apply_sampling(Sampling.hashed('f1', 5, count=100), expected_sql)

Exemplo n.º 3

Arquivo: bq_sampling_tests.py Projeto: brecht-d-m/amma-bda

 def test_hashed(self):
     expected_sql = 'SELECT * FROM (%s) WHERE ABS(HASH(f1)) %% 100 < 5' % TestCases.BASE_SQL
     self._apply_sampling(Sampling.hashed('f1', 5), expected_sql)

Exemplo n.º 4

Arquivo: bq_sampling_tests.py Projeto: CognitiveTouch/datalab

 def test_hashed_with_fields(self):
   expected_sql = 'SELECT f1 FROM (%s) WHERE ABS(HASH(f1)) %% 100 < 5' % TestCases.BASE_SQL
   self._apply_sampling(Sampling.hashed('f1', 5, fields=['f1']), expected_sql)

Exemplo n.º 5

Arquivo: bq_sampling_tests.py Projeto: CognitiveTouch/datalab

 def test_hashed_and_limited(self):
   expected_sql = 'SELECT * FROM (%s) WHERE ABS(HASH(f1)) %% 100 < 5 LIMIT 100' \
                  % TestCases.BASE_SQL
   self._apply_sampling(Sampling.hashed('f1', 5, count=100), expected_sql)

Exemplo n.º 6

Arquivo: bq_sampling_tests.py Projeto: CognitiveTouch/datalab

 def test_hashed(self):
   expected_sql = 'SELECT * FROM (%s) WHERE ABS(HASH(f1)) %% 100 < 5' % TestCases.BASE_SQL
   self._apply_sampling(Sampling.hashed('f1', 5), expected_sql)