Home » Server Options » Text & interMedia » Fulltext search (Oracle 11g or Hive 0.14.0)
Fulltext search [message #654458] Wed, 03 August 2016 04:07 Go to previous message
NikoTrend1
Messages: 4
Registered: April 2016
Junior Member
Hello, my friends)
I try to make some search in text.
And I have 2 tables. For example,
First table (CHECK_ALLTEXT T1) it's large table about 60 000 000 rows:
Title; Text
News_1; Some text about wheather
News_2; Some new text about travel and cheap avia tickets
News_3; Text about little rabbits, chickens and porks
....
News_N Information about cars, trucks, buses

Second table (CHECK_CATEGORY_DIM T2) it's small table about 1 000 rows:
Subtext; Category
little rabbit; animals
car; wehicles
....
cheap avia; travel

My goal is:
News_2, travel
News_3, animals
...
News_N, wehicles

And that's what i do:
SELECT T1.Title,
T2.Category
from CHECK_ALLTEXT T1, CHECK_CATEGORY_DIM T2
where 
T1.Text LIKE concat('%', T2.Subtext, '%');

However it works only with little tables.
Do you have any decisions of such search?
 
Read Message
Read Message
Read Message
Previous Topic: PDF to HTML convert using ctxsys.auto_filter different result db 11.2 and 12.1
Next Topic: Create Index for CLOB-datatype
Goto Forum:
  


Current Time: Tue Aug 11 23:40:41 CDT 2020