You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In IMDB database, I can execute this SQL correctly without Bao server.
SELECT DISTINCT a.name AS cast_member, t.title AS complete_dynamic_hero_movie FROM cast_info AS ci JOIN complete_cast AS cc ON ci.movie_id = cc.movie_id JOIN char_name AS chn ON chn.id = ci.person_role_id JOIN name AS a ON a.id = ci.person_id JOIN movie_info_idx AS mi ON mi.movie_id = ci.movie_id JOIN movie_keyword AS mk ON mk.movie_id = ci.movie_id JOIN keyword AS k ON k.id = mk.keyword_id JOIN title AS t ON t.id = ci.movie_id WHERE ci.person_role_id IS NOT NULL AND (chn.name LIKE '%man%' OR chn.name LIKE '%Man%') AND (k.keyword = 'superhero' OR k.keyword = 'marvel-comics' OR k.keyword = 'based-on-comic' OR k.keyword = 'tv-special' OR k.keyword = 'fight' OR k.keyword = 'violence' OR k.keyword = 'magnet' OR k.keyword = 'web' OR k.keyword = 'claw' OR k.keyword = 'laser') AND mi.info_type_id = 99 AND t.production_year > 2000 ;
However, when I am using Bao as a remcommender, it seems that Bao do not work. Then I execute the SQL by adding 'explain' in front of it. explain SELECT DISTINCT a.name AS cast_member, t.title AS complete_dynamic_hero_movie FROM cast_info AS ci JOIN complete_cast AS cc ON ci.movie_id = cc.movie_id JOIN char_name AS chn ON chn.id = ci.person_role_id JOIN name AS a ON a.id = ci.person_id JOIN movie_info_idx AS mi ON mi.movie_id = ci.movie_id JOIN movie_keyword AS mk ON mk.movie_id = ci.movie_id JOIN keyword AS k ON k.id = mk.keyword_id JOIN title AS t ON t.id = ci.movie_id WHERE ci.person_role_id IS NOT NULL AND (chn.name LIKE '%man%' OR chn.name LIKE '%Man%') AND (k.keyword = 'superhero' OR k.keyword = 'marvel-comics' OR k.keyword = 'based-on-comic' OR k.keyword = 'tv-special' OR k.keyword = 'fight' OR k.keyword = 'violence' OR k.keyword = 'magnet' OR k.keyword = 'web' OR k.keyword = 'claw' OR k.keyword = 'laser') AND mi.info_type_id = 99 AND t.production_year > 2000 ;
And it turns out to be: ERROR: unrecognized node type: 223
Then another SQL which should have been executed correctly even with Bao cannot execute anymore until I restart Bao server. I wonder if there are any methods to use Bao with SQLs as mentioned above.
The text was updated successfully, but these errors were encountered:
In IMDB database, I can execute this SQL correctly without Bao server.
SELECT DISTINCT a.name AS cast_member, t.title AS complete_dynamic_hero_movie FROM cast_info AS ci JOIN complete_cast AS cc ON ci.movie_id = cc.movie_id JOIN char_name AS chn ON chn.id = ci.person_role_id JOIN name AS a ON a.id = ci.person_id JOIN movie_info_idx AS mi ON mi.movie_id = ci.movie_id JOIN movie_keyword AS mk ON mk.movie_id = ci.movie_id JOIN keyword AS k ON k.id = mk.keyword_id JOIN title AS t ON t.id = ci.movie_id WHERE ci.person_role_id IS NOT NULL AND (chn.name LIKE '%man%' OR chn.name LIKE '%Man%') AND (k.keyword = 'superhero' OR k.keyword = 'marvel-comics' OR k.keyword = 'based-on-comic' OR k.keyword = 'tv-special' OR k.keyword = 'fight' OR k.keyword = 'violence' OR k.keyword = 'magnet' OR k.keyword = 'web' OR k.keyword = 'claw' OR k.keyword = 'laser') AND mi.info_type_id = 99 AND t.production_year > 2000 ;
However, when I am using Bao as a remcommender, it seems that Bao do not work. Then I execute the SQL by adding 'explain' in front of it.
explain SELECT DISTINCT a.name AS cast_member, t.title AS complete_dynamic_hero_movie FROM cast_info AS ci JOIN complete_cast AS cc ON ci.movie_id = cc.movie_id JOIN char_name AS chn ON chn.id = ci.person_role_id JOIN name AS a ON a.id = ci.person_id JOIN movie_info_idx AS mi ON mi.movie_id = ci.movie_id JOIN movie_keyword AS mk ON mk.movie_id = ci.movie_id JOIN keyword AS k ON k.id = mk.keyword_id JOIN title AS t ON t.id = ci.movie_id WHERE ci.person_role_id IS NOT NULL AND (chn.name LIKE '%man%' OR chn.name LIKE '%Man%') AND (k.keyword = 'superhero' OR k.keyword = 'marvel-comics' OR k.keyword = 'based-on-comic' OR k.keyword = 'tv-special' OR k.keyword = 'fight' OR k.keyword = 'violence' OR k.keyword = 'magnet' OR k.keyword = 'web' OR k.keyword = 'claw' OR k.keyword = 'laser') AND mi.info_type_id = 99 AND t.production_year > 2000 ;
And it turns out to be:
ERROR: unrecognized node type: 223
Then another SQL which should have been executed correctly even with Bao cannot execute anymore until I restart Bao server. I wonder if there are any methods to use Bao with SQLs as mentioned above.
The text was updated successfully, but these errors were encountered: