[
https://issues.apache.org/jira/browse/DRILL-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandi Spinn closed DRILL-6091.
-------------------------------
Resolution: Unresolved
> 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
> Priority: Major
>
> 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)
