Tweetmap Searches and Hashtag Filtering don't work


#1

Hi,
I have setup Tweetmap to point to my local MapD Core instance. All the functionalities like Search Location, filter by Language/Source works well except Search Tweets and filter by Hashtags which they return null tweets.
The same Tweetmap application when i point to the remote database hosted here metis.mapd.com both Search Tweets and filter by Hashtags work.

Below is my table schema:
CREATE TABLE tweets_small (
tweet_id BIGINT,
tweet_time TIMESTAMP ENCODING FIXED(32),
lat FLOAT,
lon FLOAT,
sender_name TEXT ENCODING DICT(32),
lang TEXT ENCODING DICT(8),
tweet_text TEXT ENCODING NONE,
origin TEXT ENCODING DICT(8),
hashtags TEXT[] ENCODING DICT(32),
tweet_tokens TEXT[] ENCODING DICT(32)
)

Does it mean i have to use the full schema table to have all the functionalities working. Kindly help.

Regards,
Mark


#2

Hi,

Can you confirm that the ‘pakistan’ query filter is reaching the mapd databse, we can do this by sharing the mapd_server.INFO log here.

Are you sure you have a tweet or a hashtag with that value ‘pakistan’ please run a simple mapdql or SQL Editor query to confirm your assumptions around the data content. It requires that the arrays tweet_token has an entry with that exact text.

regards.