drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kunal Khatua (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-6091) Continued Validation Error - Replacing Tables
Date Mon, 05 Feb 2018 02:05:00 GMT

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

Mime
View raw message