Brandi Spinn created DRILL-6091:
-----------------------------------
Summary: Continued Validation Error - Replacing Tables
Key: DRILL-6091
URL: https://issues.apache.org/jira/browse/DRILL-6091
Project: Apache Drill
Issue Type: Bug
Reporter: Brandi Spinn
We are currently running a project which is utilizing the Drill push to Tableau
function to be able to work with our data sets, we are already working with
Tableau regarding our needs and determined that this is our best course of
action considering how large data sets are - over 2 million rows per day.
At the moment we have several visualizations we have published, but we are
running in an issue each morning where some of them are not updating according
to our schedules, and when we review the logs we find some the same type of
"fatal" errors that do not always allow the visualizations to update. We also
continually run into "drill server down" errors.
I have reached out to our account rep through Tableau for possible guidance,
however, they have indicated that it is not an issue on the Tableau side -
which we figured.
Below is a sample of the error codes we are seeing, please let me know you are
able to assist or if you need any additional information. Thank you!
|_Auto_AOD_Content:288 - create table dfs.tmp.attributes as select distinct
channels.marketingname as channelmarketingname, channels.streamingname as
channelstreamingname, channels.channelguid as channelGuid, channels.channelid
as channelId, categories.category_name as channelcategory, CASE when
music.channel_guid is not null then 'Music' else null end as genre_Music, CASE
when news.channel_guid is not null then 'News' else null end as genre_News,
CASE when sports.channel_guid is not null then 'Sports' else null end as
genre_Sports, CASE when talk.channel_guid is not null then 'Talk' else null
end as genre_Talk, CASE when howard.channel_guid is not null then 'Howard' else
null end as genre_Howard, categories.channel_name channelName from
dfs.root.`/SXM/archive/parsed/Channel-parsed-type2/2017-12-14*` channels join
dfs.root.`/SXM/archive/parsed/category-parsed-type2/2017-12-14*` categories on
categories.channel_guid=channels.channelguid left join (select channel_guid
from dfs.root.`/SXM/archive/parsed/category-parsed-type2/2017-12-14*` where
supercategory_name = 'Music') music on channels.channelguid =
music.channel_guid left join (select channel_guid from
dfs.root.`/SXM/archive/parsed/category-parsed-type2/2017-12-14*` where
supercategory_name = 'News') news on channels.channelguid = news.channel_guid
left join (select channel_guid from
dfs.root.`/SXM/archive/parsed/category-parsed-type2/2017-12-14*` where
supercategory_name = 'Sports') sports on channels.channelguid =
sports.channel_guid left join (select channel_guid from
dfs.root.`/SXM/archive/parsed/category-parsed-type2/2017-12-14*` where
supercategory_name = 'Talk') talk on channels.channelguid = talk.channel_guid
left join (select channel_guid from
dfs.root.`/SXM/archive/parsed/category-parsed-type2/2017-12-14*` where
supercategory_name = 'Howard') howard on channels.channelguid =
howard.channel_guid_|
|_Auto_AOD_Content:304 - There was a SQL ERROR on DRILL side_|
|_Auto_AOD_Content:305 - VALIDATION ERROR: A table or view with given name
[attributes] already exists in schema [dfs.tmp]_|
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
