1. Joins, yes we need to understand it

2. "dec" is a reserved word, but it should not crash czar, I created a 
story, see DM-3361 (and just don't try to select "dec" for now, it will 
never work)

3. fluxToAbMag should really be something like scisql_fluxToAbMag, see:
     grep flux qserv_testdata/datasets/case01/queries/*.sql

4. self join - I'd like to hear what Serge says about it

Jacek



On 7/31/15 4:12 PM, John Gates wrote:
> The large_scale_tests file is in 
> /afs/slac.stanford.edu/u/sf/jgates/Public/, and I attached it since it 
> small. About 150 lines in I put in the queries that cause problems.
>
> The sum up so far is the simple things appear to work. Running 
> multiple queries at the same time is fine.
>
> I tired a very simple join and the cluster hung. I could talk to the 
> czar but queries were not being answered. Canceling was not really 
> successful. The czar log looks like it was trying to answer the query 
> but nothing ever came back from the workers.
>
> Having dec instead of decl crashed the czar.
>
> I doesn't seem to know about  mysql.fluxToAbMag.
>
> -John

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1