With Pluse v0.5.4, how to get columns with names starting with 'v1_' in the tweets table ?

The v1_* columns are derived from views of the tweet_sentiment table and used within the example Tableau workbook.

The example SQL to create views is shown below. Change keywords to match data collected in sentiment table. In this example mobile cell carriers were used as keywords in the v1_words view.

 

drop view if exists v1_words;

create view v1_words as

select

        attribute,

        sentiment_score,

        id

from

        tweet_sentiment

where

        attribute='verizon' or

        attribute='att'     or

        attribute='sprint'  or

        attribute='tmobile'

;

 

drop view if exists v1_negative_words;

 

create view v1_negative_words as

select

        attribute,

        sentiment_score,

        id

from

        tweet_sentiment

where

        sentiment_score < 0

;

 

drop view if exists v1_positive_words;

 

create view v1_positive_words as

select

        attribute,

        sentiment_score,

        id

from

        tweet_sentiment

where

        sentiment_score > 0

;

 

-- detail view

 

drop view if exists v1_word_detail;

 

create view v1_word_detail as

select

        tweets.id,

        text,

        attribute,

        sentiment_score

from

        tweets, tweet_sentiment

where

        tweets.id=tweet_sentiment.id

;