I formatted a csv file from gcs, but when I queried it, I got an error: Object ‘json’ not found
ca328fd1-fee3-41b7-a193-5542ea7fa30a.zip (20.0 KB)
@fuliu Object ‘json’ not found is an internal job failure. I saw your profile and the error is
Current and given configurations for source [gcs] have same etag (a7OM2hkUK0c=) but different values [current source: [source: SourceConfig{id=EntityId{id=13bd423e-ef60-4274-843e-962e6005fa7f}, legacySourceTypeEnum=null, name=gcs, ctime=0, img=null, description=null, config=null, version=null, accelerationTTL=null, metadataPolicy=MetadataPolicy{namesRefreshMs=3600000, datasetUpdateMode=PREFETCH_QUERIED, datasetDefinitionTtlMs=null, authTtlMs=86400000, datasetDefinitionRefreshAfterMs=3600000, datasetDefinitionExpireAfterMs=10800000, deleteUnavailableDatasets=true, autoPromoteDatasets=false}, lastRefreshDate=null, accelerationRefreshPeriod=3600000, accelerationGracePeriod=10800000, type=GCS, accelerationNeverExpire=false, accelerationNeverRefresh=false, tag=a7OM2hkUK0c=, configOrdinal=1, allowCrossSourceSelection=false, checkTableAuthorizer=true, disableMetadataValidityCheck=false, isPrimaryCatalog=false, lastModifiedAt=null, accelerationActivePolicyType=PERIOD, accelerationRefreshSchedule=null, accelerationRefreshOnDataChanges=false, sourceChangeState=SOURCE_CHANGE_STATE_UPDATING}, connection: {"type":"GCSConf","projectId":"fifth-sol-426804-j7","authMode":"SERVICE_ACCOUNT_KEYS","propertyList":null,"rootPath":"/","bucketWhitelist":null,"asyncEnabled":true,"cachingEnable":true,"cachePercent":70,"privateKeyId":"d6445885a4ecccf964f1bd38ea8810c66341d3d1","privateKey":{"uri":null},"clientEmail":"dbt-406@fifth-sol-426804-j7.iam.gserviceaccount.com","clientId":"112513066107017913501","defaultCtasFormat":"ICEBERG","isPartitionInferenceEnabled":false}], given source: [source: SourceConfig{id=EntityId{id=13bd423e-ef60-4274-843e-962e6005fa7f}, legacySourceTypeEnum=null, name=gcs, ctime=0, img=null, description=null, config=null, version=null, accelerationTTL=null, metadataPolicy=MetadataPolicy{namesRefreshMs=3600000, datasetUpdateMode=PREFETCH_QUERIED, datasetDefinitionTtlMs=null, authTtlMs=86400000, datasetDefinitionRefreshAfterMs=3600000, datasetDefinitionExpireAfterMs=10800000, deleteUnavailableDatasets=true, autoPromoteDatasets=false}, lastRefreshDate=null, accelerationRefreshPeriod=3600000, accelerationGracePeriod=10800000, type=GCS, accelerationNeverExpire=false, accelerationNeverRefresh=false, tag=a7OM2hkUK0c=, configOrdinal=1, allowCrossSourceSelection=false, checkTableAuthorizer=true, disableMetadataValidityCheck=false, isPrimaryCatalog=false, lastModifiedAt=null, accelerationActivePolicyType=PERIOD, accelerationRefreshSchedule=0 0 8 * * *, accelerationRefreshOnDataChanges=false, sourceChangeState=SOURCE_CHANGE_STATE_NONE}, connection: {"type":"GCSConf","projectId":"fifth-sol-426804-j7","authMode":"SERVICE_ACCOUNT_KEYS","propertyList":null,"rootPath":"/","bucketWhitelist":null,"asyncEnabled":true,"cachingEnable":true,"cachePercent":70,"privateKeyId":"d6445885a4ecccf964f1bd38ea8810c66341d3d1","privateKey":{"uri":null},"clientEmail":"dbt-406@fifth-sol-426804-j7.iam.gserviceaccount.com","clientId":"112513066107017913501","defaultCtasFormat":"ICEBERG","isPartitionInferenceEnabled":false}]]
Can you try to restart Dremio and retry the query?
Thanks for your help, it’s work，why would a reboot fix it?
@fuliu In an edge case the internal database was out of sync, thats why tried a restart