When null data is present in a non-nullable column, preview keeps spinning

Description

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

Release Notes

None

Attachments

1

Activity

Show:

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.'

Cannot Reproduce
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Affects versions

Components

Fix versions

Priority

Created February 22, 2017 at 6:51 PM
Updated April 27, 2017 at 2:15 AM
Resolved April 20, 2017 at 5:49 PM