When null data is present in a non-nullable column, preview keeps spinning
Description
Release Notes
Attachments
Activity
Bhooshan Mogal February 24, 2017 at 12:20 AM
Tried multiple ways of reproducing this issue. The pipelines in question fail because of data errors in both 4.0 and 4.1. , it would be great if you could help narrow this down to a few general steps to reproduce, after cleaning up the data.
Bhooshan Mogal February 23, 2017 at 9:03 PM
Assigning to to reproduce the issue.
Dave Finnegan February 22, 2017 at 7:58 PM
Attached that tail of the cdap.log for the timeframe I was testing
Bhooshan Mogal February 22, 2017 at 7:40 PM
Can you please attach the standalone logs at the time you ran these queries? Are there any errors in the logs?
Dave Finnegan February 22, 2017 at 7:33 PM
New UI, CDAP Explore page: SELECT * FROM cdap_Customer360.dataset_c360webrequests LIMIT 500
never returns
Old UI, CDAP Explore page: SELECT * FROM default.dataset_c360webrequests LIMIT 5
default. should not be there, as I'm in the Customer360 namespace
once removing the 'default.' the query returns an empty result, althogh the status page for the dataset shows 4.1MB of data
Tracker preview never returns; just shows 'obtaining preview data' and spins for ever
from the cdap cli:
execute 'select * from dataset_c360webrequests limit 5'
Error: co.cask.cdap.explore.service.ExploreException: Cannot get next results. Reason: Response code: 500, message: 'Internal Server Error', body: 'No value for custid exists.'
Ran a pipeline, then went to tracker. Not enabled. Enabled it, then ran a search. It never returned.
Back to pipeline, select dataset, jump to dataset goes to empty page.
In CDAP, browse to dataset - shows 28k of data, explore shows error:
400 [SQLState 42S02] Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'dataset_games'
Today at 1:51 PM