Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Facet vs count distinct #19

Closed
airolg opened this issue Oct 19, 2017 · 1 comment
Closed

Facet vs count distinct #19

airolg opened this issue Oct 19, 2017 · 1 comment

Comments

@airolg
Copy link
Contributor

airolg commented Oct 19, 2017

INTERNAL ERROR: column '@distinct/count(distinct gid)' not found in result set schema

Конфиг Sphinx:

searchd
{
    listen = 9316
    listen = 9306:mysql41
    
    pid_file = c:\sphinx\searchd.pid
    log = c:\sphinx\log\log.txt
    query_log = c:\sphinx\log\query_log.txt
    binlog_path = c:\sphinx\binlog
}

source test
{
    type = csvpipe
    
    csvpipe_attr_uint = gid
    
    csvpipe_attr_uint = brand_id
    csvpipe_field_string = brand_name
    
    csvpipe_attr_uint = color_id
    csvpipe_field_string = color_name
    
    csvpipe_delimiter = ;
    csvpipe_command = \
        @echo 1;5;7;Apple;9;Black &\
        @echo 2;5;7;Apple;10;White &\
        @echo 3;6;8;Samsung;9;Black &\
        @echo 4;6;8;Samsung;10;White &\
        
}

index test
{
    source = test
    path = c:\sphinx\index\test
}

Запрос:

select gid, count(distinct gid) from test group by gid
facet brand_id, brand_name by brand_id order by count(*) desc
facet color_id, color_name by color_id order by count(*) desc;

Возникает ошибка:
INTERNAL ERROR: column '@distinct/count(distinct gid)' not found in result set schema

А также в searchd:
WARNING: bailing on failed MySQL header (client=127.0.0.1:10003(6)), error: 10053 'WSA error 10053', sock=316

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant