QSense load and filed name

[#1]

Hello all,

I'am using Qsense

And I would like to understand why :

SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';
SET FirstWeekDay=0;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='fr-FR';

LIB CONNECT TO 'OTRS Prod';

in_map:
load ticket_id as id, create_time as create_time;
select ticket_id, min(create_time) as create_time
from ticket_history where
history_type_id=16 and (name like "\%\%Hotline\%\%%\%\%%\%\%%" or name like "\%\%D3 Alerts\%\%%\%\%%\%\%%")
group by id;

out_map:
load ticket_id as id, create_time as create_time;
select ticket_id, min(create_time) as create_time
from ticket_history where
history_type_id =16 and (name like "\%\%%\%\%Hotline\%\%%" or name like "\%\%%\%\%D3 Alerts\%\%%")
group by ticket_id;

Give me only one table in_map ?

is it a bug or not ?

if I change the file name to be different is would create me two table ?!!

[hic]

If two load statements have identical output fields, the tables will be concatenated into one table. So, if you want two tables, you should use other aliases for the fields.

HIC

[#3]

ok thks henric,

so the table table of the load is useless ?

[#4]

so the table name of the load is useless ?

[hic]

It's not useless but it doesn't influence how the loaded data is stored.

HIC