Skip to Content
Author's profile photo Tom Flanagan

[SAP HANA Academy] Live3: Create Tweets Table

[Update: April 5th, 2016 –  The Live3 on HCP tutorial series was created using the SAP HANA Cloud Platform free developer trial landscape in January 2015. The HCP landscape has significantly evolved over the past year. Therefore one may encounter many issues while following along with the series using the most recent version of the free developer trail edition of HCP.]

In a tutorial video from the SAP HANA Academy Philip Mugglestone shows how to create a new SAP HANA database table that will contain the tweets we will analyze. The table’s data will be populated in real-time via the Twitter API. Watch Philip’s tutorial video below.

Screen Shot 2015-02-25 at 6.30.38 PM.png

(0:30 – 4:10) How to Create a Table in a SAP HANA Instance

First ensure that you’re in the proper schema by following the steps in the previous video. In the scripts folder of the Live3 course Github code repository open the file called 02 setupTable.sql with Notepad++. Copy the syntax and paste it into a SQL console in Eclipse.

We will create a column table to better take advantage of SAP HANA’s amazing power as a columnar storage database. The table name, Tweets, is in double quotes as we are using a mixed case title. The syntax also defines the columns in our table including the text, language, user, and location. The primary key will identify each individual tweet using VARCAR with a 256 length.

Screen Shot 2015-02-25 at 6.29.53 PM.png

Highlight and then run the syntax to create the Tweets table. To confirm the Tweets table’s creation expand the Tables folder within the Schema folder to see a Tweets table that currently contains no data.

Screen Shot 2015-02-25 at 6.34.11 PM.png

Follow along with the Live3 course here.

SAP HANA Academy over 900 free tutorial videos on using SAP HANA and SAP HANA Cloud Platform.

Follow @saphanaacademy

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.