QSense load and filed name

Thu, 10 Sep 2015 12:19:44 GMT

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 ?!!

Re: QSense load and filed name

hic — Thu, 10 Sep 2015 12:36:53 GMT

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

Re: QSense load and filed name

Fri, 25 Sep 2015 14:01:58 GMT

ok thks henric,

so the table table of the load is useless ?

Re: QSense load and filed name

Fri, 25 Sep 2015 14:02:33 GMT

so the table name of the load is useless ?

Re: QSense load and filed name

hic — Fri, 25 Sep 2015 14:50:41 GMT

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

HIC

topic QSense load and filed name in App Development

QSense load and filed name

Re: QSense load and filed name

Re: QSense load and filed name

Re: QSense load and filed name

Re: QSense load and filed name