Twitter Search based on variable in SQL

Is there any way for me to search the query in twitter by using sql instead using the
“twitter search” node ? I want my list of query will be in the sql. Thank you !

Hello Gua_gunners,

Are you able to load the Tweets into a store that utilizes SQL? Either a database, Hive, Spark or another analytics datastore could work.

Thanks,
Gamble

hi @ggruff,

Im able to load the tweets in KNIME, but I cant store it into SQL because of the truncated tweets. Based on this link (How do I remove truncated string ?). The new updates will be release in summer, by then probably I can store my tweets in SQL without any truncated tweets problem.

1 Like

If you’d like to try out our nightly build, the bug with truncated tweets is fixed there: https://www.knime.com/form/nightly-build

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.