Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?!!
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
ok thks henric,
so the table table of the load is useless ?
so the table name of the load is useless ?
It's not useless but it doesn't influence how the loaded data is stored.
HIC