[ 
https://issues.apache.org/jira/browse/DRILL-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16351977#comment-16351977
 ] 

Kunal Khatua commented on DRILL-6091:
-------------------------------------

Hi [~BSpinn] 

What was the solution for this resolving this?

> 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)

Reply via email to