Extensions: firebase-bigquery-export: Array Type - No rows results

Created on 22 Jun 2020 · 4Comments · Source: firebase/extensions

[REQUIRED] Step 2: Describe your configuration

Extension name: \Export Collections to BigQuery
Extension version: 0.1.5

[REQUIRED] Step 3: Describe the problem

When generating a view with array type data and querying for latest returns: 'This query returned no results.'

Steps to reproduce:

1.-Install extension on collection 'examples'
2.-Create a collection called 'examples'
3.-Fill collection with document:

4.- Create the scheme views with the following example.json

{
  "fields": [
    {
      "name": "name",
      "type": "string"
    },
    {
      "name":"favorite_numbers",
      "type": "array"
    },
    {
      "name": "last_login",
      "type": "timestamp"
    }
  ]
}

5.- Go to google cloud platform big query, and query examples_raw_latest to verify that data exists on big query

6.- Go to the created view (examples_schema_example_latest) and query all data (no results)

7.- Create another schema called exampleSimple.json in which the array data type is deleted

{
  "fields": [
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "last_login",
      "type": "timestamp"
    }
  ]
}

Create views and query results:

Now you can see the result.

Expected result

Expected to see a row with favorite_numbers_member and favorite_numbers_index

Actual result

'This query returned no results.'

bug

Source

diegofhe

👍2 ❤1

Most helpful comment

Hello @LucianoGanga, my project is still on development , so this issue is not critical to me (I am waiting for the firebase team to merge the fix on 368). The first thing that comes to mind is to twerk the query on ${schema}_latest on "details" tab.