We are a working on a demo application on SAP HANA Cloud Trial, wherein we have created a full text index on a column store table.
Our index name is TEXT_FTI and accordingly an index table with the name $TA_TEXT_FTI has been created by the HANA DB.
But this table strangely has no values. We are storing a maximum of 200 characters at a time, hence I don't think the size of the text should be a problem (as pointed out by experts in some blogs)
Below is the code I'm using to create the Index.
PreparedStatement pstmtIndex = connection.prepareStatement("CREATE FULLTEXT INDEX \"TEXT_FTI\" ON \"TWEETS\" (\"TEXT\") TEXT ANALYSIS ON CONFIGURATION 'EXTRACTION_CORE' LANGUAGE DETECTION ('EN')");
And Below is the piece of code used to fetch entries from index table
PreparedStatement pstmt = connection
.prepareStatement("SELECT ID, TA_TYPE FROM \"$TA_TEXT_FTI\"");
ResultSet rs = pstmt.executeQuery();
The above query does not generate any results, although the table $TA_TEXT_FTI exists in the schema.
Could any of you please help me figure out what the problem may be?
Also, is there any way we can view the database for the HANA Cloud DB? I found a way for that only for MaxDB, not for HANA DB.