[
https://issues.apache.org/jira/browse/DRILL-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16352534#comment-16352534
]
Brandi Spinn commented on DRILL-6091:
-------------------------------------
Hi Kunal Khatua
No resolution as of now - I closed the issue thinking I had made an error in
opening it - and I am continuing to monitor issues being opened for anything
similar.
We are still experiencing this issue each day - and troubleshooting possible
causes, at the moment it points to a memory issues since we are also seeing our
drills go down each day with the processing. We also think an issue is being
caused by us amending the files each day instead of creating new files/file
names. I've seen new "system" and "validation" errors show up recently that are
helping in our search but still nothing conclusive.
Is this something I should reopen? Thank you for your interest!
> 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)
