llua_mattermost_message_star-dist Normal 0 / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT
ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE
0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 cluster N dynamic Y 1 ati-dev-ana01 ati-dev-ana01 9081 pentaho-di njain Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N ATI-PRD-ANA03 ATI-PRD-ANA03 9080 pentaho-di admin Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde N N ATI-STG-ANA03 ATI-STG-ANA03 9080 pentaho-di pentaho Encrypted 2be98afc86aa7f2b4ae17ba71d69dff8b N N DI Server localhost 9080 pentaho-di joe Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N DI Server 5.0 localhost 9080 pentaho-di admin Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N local 127.0.0.1 9080 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 Y N Master localhost 8081 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 Y N remote 192.168.1.16 9080 pentaho-di/kettle admin Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N Slave1 localhost 8082 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave2 localhost 8083 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave3 localhost 8084 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave4 localhost 8085 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave5 localhost 8086 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N ClusterSchema 40000 2000 5000 Y N Slave3 Slave2 Slave1 Master ClusterSchema_dynamic 40000 2000 5000 Y Y Master - 2021/06/17 15:32:05.046 schmitz 2022/04/13 15:21:30.775 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N Extract and Transform 0 16 145 26 .AppleSystemUIFont 13 N N 0 0 0 255 205 112 100 100 100 Y Load 0 2128 40 26 .AppleSystemUIFont 13 N N 0 0 0 255 205 112 100 100 100 Y Data Warehouse [ihre_domain/container_name] POSTGRESQL Native datawarehouse [host/container_port] datawarehouse Encrypted 6461746175dfeacaa005d28181bb18bd63c99dbdde FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER [host/container_port] PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE N SUPPORTS_TIMESTAMP_DATA_TYPE N USE_POOLING N Mattermost DB [ihre_domain/container_name] POSTGRESQL Native mattermost [host/container_port] mmuser Encrypted 2be98afc86aa79f89bb18bd63c99dbdde FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER [host/container_port] PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N Input fileinfo Select values fileinfo Y Input teams Select values teams Y Input user Select values user Y Input channels Select values channels Y Select values fileinfo Sort rows fileinfo Y Select values channels Sort rows channels Y Input posts Select values posts Y Select values posts Sort rows posts Y Select values user Sort rows user Y Sort rows posts Merge join posts & user Y Sort rows user Merge join posts & user Y Select values posts & user Sort rows posts & user Y Sort rows posts & user Merge join posts & user & channels Y Sort rows channels Merge join posts & user & channels Y Merge join posts & user & channels Select values remove channelID_1 Y Select values teams Sort rows teams Y Select values remove channelID_1 Sort rows teamid Y Sort rows teamid Merge join teamid - id Y Sort rows teams Merge join teamid - id Y Merge join teamid - id Select values remove id, rename name_1 to teamname Y Select values remove id, rename name_1 to teamname Sort rows postID Y Sort rows fileinfo Merge join postID - postid Y Sort rows postID Merge join postID - postid Y Merge join postID - postid Select values remove postid_1 Y Input threads Select values threads Y Select values threads Sort rows threads Y Select values remove postid_1 Sort rows postID 2 Y Sort rows threads Merge join postID - postid 2 Y Sort rows postID 2 Merge join postID - postid 2 Y Calculator split timestamp Select values rename postID to messageID and name to channelname Y Maintable Combination create_time Y Combination create_time Select values: rename id to create_time_id Y Select values: rename id to create_time_id Combination delete_time Y Combination delete_time Select values: rename id to delete_time_id Y Select values: rename id to delete_time_id Combination create_date Y Combination create_date Select values: rename id to create_date_id Y Select values: rename id to create_date_id Combination delete_date Y Combination delete_date Select values: rename id to delete_date_id Y Select values: rename id to delete_date_id Combination channel Y Combination channel Select values: rename id to channel_id Y Select values: rename id to channel_id Combination fileinfo Y Combination fileinfo Select values: rename id to fileinfo_id Y Combination user Select values: rename id to user_id Y Select values: rename id to user_id Combination team Y Combination team Select values: rename id to team_id Y Select values: rename id to team_id Combination thread Y Combination thread Select values: rename id to thread_id Y Select values: rename id to thread_id Blocking step Y Blocking step Insert / update boolean Y Merge join posts & user Formula: check if user still exists Y Formula: check if user still exists Select values posts & user Y Select values: rename id to fileinfo_id Combination user Y Merge join postID - postid 2 Calculator split timestamp Y Maintable Concat fields: create date & time Y Concat fields: create date & time Concat fields: delete date & time 2 Y Concat fields: delete date & time 2 Text file output: CSV for PM Y Select values rename postID to messageID and name to channelname Select values remove unnecessary data Y Select values remove unnecessary data Maintable Y Blocking step BlockingStep Y 1 none Y %%java.io.tmpdir%% block 5000 Y 688 3888 Y Calculator split timestamp Calculator Y 1 none Y create_year YEAR_OF_DATE createat None -1 -1 N create_month MONTH_OF_DATE createat None -1 -1 N create_day DAY_OF_MONTH createat None -1 -1 N create_hour HOUR_OF_DAY createat None -1 -1 N create_minute MINUTE_OF_HOUR createat None -1 -1 N create_second SECOND_OF_MINUTE createat None -1 -1 N delete_year YEAR_OF_DATE deleteat None -1 -1 N delete_month MONTH_OF_DATE deleteat None -1 -1 N delete_day DAY_OF_MONTH deleteat None -1 -1 N delete_hour HOUR_OF_DAY deleteat None -1 -1 N delete_minute MINUTE_OF_HOUR deleteat None -1 -1 N delete_second SECOND_OF_MINUTE deleteat None -1 -1 N 688 1760 Y Combination channel CombinationLookup Y 1 none llua_mattermost_message
dim_channel
Data Warehouse 100 9999 Y N N hashcode channelname name id tablemax N 688 2912 Y Combination create_date CombinationLookup Y 1 none llua_mattermost_message dim_date
Data Warehouse 100 9999 Y N N hashcode create_year year create_month month create_day day id autoinc Y 688 2544 Y Combination create_time CombinationLookup Y 1 none llua_mattermost_message dim_time
Data Warehouse 100 9999 Y N N hashcode create_hour hour create_minute minute create_second second id autoinc Y 688 2208 Y Combination delete_date CombinationLookup Y 1 none llua_mattermost_message dim_date
Data Warehouse 100 9999 Y N N hashcode delete_year year delete_month month delete_day day id autoinc Y 688 2720 Y Combination delete_time CombinationLookup Y 1 none llua_mattermost_message dim_time
Data Warehouse 100 9999 Y N N hashcode delete_hour hour delete_minute minute delete_second second id autoinc Y 688 2384 Y Combination fileinfo CombinationLookup Y 1 none llua_mattermost_message dim_fileinfo
Data Warehouse 100 9999 Y N N hashcode extension extension size size id tablemax N 688 3104 Y Combination team CombinationLookup Y 1 none llua_mattermost_message dim_team
Data Warehouse 100 9999 Y N N hashcode teamname name id tablemax N 688 3488 Y Combination thread CombinationLookup Y 1 none llua_mattermost_message dim_thread
Data Warehouse 100 9999 Y N N hashcode replycount replycount id tablemax N 688 3696 Y Combination user CombinationLookup Y 1 none llua_mattermost_message dim_user
Data Warehouse 100 9999 Y N N hashcode username username exists exists id tablemax N 688 3296 Y Concat fields: create date & time ConcatFields Y 1 none - " N N
N
N
DOS None N Y N Y txt N N N N N N Y N N 0 create_year None none -1 -1 create_month None none -1 -1 create_day None none -1 -1 create_hour None none -1 -1 create_minute None none -1 -1 create_second None none -1 -1 create_date_time 255 N 912 2208 Y Concat fields: delete date & time 2 ConcatFields Y 1 none - " N N
N
N
DOS None N Y N Y txt N N N N N N Y N N 0 delete_year None none -1 -1 delete_month None none -1 -1 delete_day None none -1 -1 delete_hour None none -1 -1 delete_minute None none -1 -1 delete_second None none -1 -1 delete_date_time 255 N 1152 2208 Y Formula: check if user still exists Formula Y 1 none exists ISBLANK([deleteat]) Boolean -1 -1 688 288 Y Input channels TableInput Y 1 none Mattermost DB SELECT id , createat , updateat , deleteat , teamid , "type" , "name" , lastpostat , totalmsgcount , extraupdateat , creatorid , schemeid , groupconstrained , shared , totalmsgcountroot FROM public.posts 0 N N N N String normal id 32 -1 Input channels id . , none N Y 0 N N N en_US Europe/Berlin N Integer normal createat 15 0 Input channels createat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal updateat 15 0 Input channels updateat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal deleteat 15 0 Input channels deleteat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal teamid 32 -1 Input channels teamid . , none N Y 0 N N N en_US Europe/Berlin N String normal type 1 -1 Input channels type . , none N Y 0 N N N en_US Europe/Berlin N String normal name 32 -1 Input channels name . , none N Y 0 N N N en_US Europe/Berlin N Integer normal lastpostat 15 0 Input channels lastpostat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal totalmsgcount 15 0 Input channels totalmsgcount ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal extraupdateat 15 0 Input channels extraupdateat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal creatorid 32 -1 Input channels creatorid . , none N Y 0 N N N en_US Europe/Berlin N String normal schemeid 26 -1 Input channels schemeid . , none N Y 0 N N N en_US Europe/Berlin N Boolean normal groupconstrained -1 -1 Input channels groupconstrained . , none N Y 0 N N N en_US Europe/Berlin N Boolean normal shared -1 -1 Input channels shared . , none N Y 0 N N N en_US Europe/Berlin N Integer normal totalmsgcountroot 15 0 Input channels totalmsgcountroot ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N 128 640 Y Input fileinfo TableInput Y 1 none Mattermost DB SELECT id , creatorid , postid , createat , updateat , deleteat , extension , "size" , mimetype FROM public.posts 0 N N N N String normal id 32 -1 Input file info id , . none N Y 0 N N N en_US Europe/Berlin N String normal creatorid 32 -1 Input file info creatorid , . none N Y 0 N N N en_US Europe/Berlin N String normal postid 32 -1 Input file info postid , . none N Y 0 N N N en_US Europe/Berlin N Integer normal createat 15 0 Input file info createat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Integer normal updateat 15 0 Input file info updateat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Integer normal deleteat 15 0 Input file info deleteat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal extension 64 -1 Input file info extension , . none N Y 0 N N N en_US Europe/Berlin N Integer normal size 15 0 Input file info size ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal mimetype 256 -1 Input file info mimetype , . none N Y 0 N N N en_US Europe/Berlin N 128 1296 Y Input posts TableInput Y 1 none Mattermost DB SELECT id , createat , updateat , editat , deleteat , ispinned , userid , channelid , rootid , originalid , "type" , hasreactions FROM public.posts 0 N N N N String normal id 32 -1 Input posts id . , none N Y 0 N N N en_US Europe/Berlin N Integer normal createat 15 0 Input posts createat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal updateat 15 0 Input posts updateat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal editat 15 0 Input posts editat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal deleteat 15 0 Input posts deleteat ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Boolean normal ispinned -1 -1 Input posts ispinned . , none N Y 0 N N N en_US Europe/Berlin N String normal userid 32 -1 Input posts userid . , none N Y 0 N N N en_US Europe/Berlin N String normal channelid 32 -1 Input posts channelid . , none N Y 0 N N N en_US Europe/Berlin N String normal rootid 32 -1 Input posts rootid . , none N Y 0 N N N en_US Europe/Berlin N String normal originalid 32 -1 Input posts originalid . , none N Y 0 N N N en_US Europe/Berlin N String normal type 26 -1 Input posts type . , none N Y 0 N N N en_US Europe/Berlin N Boolean normal hasreactions -1 -1 Input posts hasreactions . , none N Y 0 N N N en_US Europe/Berlin N 128 80 Y Input teams TableInput Y 1 none Mattermost DB SELECT id , createat , updateat , deleteat , displayname , "name" , "type" , companyname , allowopeninvite , lastteamiconupdate , schemeid , groupconstrained FROM public.posts 0 N N N N String normal id 32 -1 Input teams id , . none N Y 0 N N N en_US Europe/Berlin N Integer normal createat 15 0 Input teams createat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Integer normal updateat 15 0 Input teams updateat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Integer normal deleteat 15 0 Input teams deleteat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal displayname 64 -1 Input teams displayname , . none N Y 0 N N N en_US Europe/Berlin N String normal name 64 -1 Input teams name , . none N Y 0 N N N en_US Europe/Berlin N String normal type 255 -1 Input teams type , . none N Y 0 N N N en_US Europe/Berlin N String normal companyname 64 -1 Input teams companyname , . none N Y 0 N N N en_US Europe/Berlin N Boolean normal allowopeninvite -1 -1 Input teams allowopeninvite , . none N Y 0 N N N en_US Europe/Berlin N Integer normal lastteamiconupdate 15 0 Input teams lastteamiconupdate ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal schemeid 26 -1 Input teams schemeid , . none N Y 0 N N N en_US Europe/Berlin N Boolean normal groupconstrained -1 -1 Input teams groupconstrained , . none N Y 0 N N N en_US Europe/Berlin N 128 992 Y Input threads TableInput Y 1 none Mattermost DB SELECT postid , channelid , replycount , lastreplyat FROM public.posts 0 N N N N String normal postid 32 -1 Input threads postid , . none N Y 0 N N N en_US Europe/Berlin N String normal channelid 32 -1 Input threads channelid , . none N Y 0 N N N en_US Europe/Berlin N Integer normal replycount 15 0 Input threads replycount ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Integer normal lastreplyat 15 0 Input threads lastreplyat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N 128 1648 Y Input user TableInput Y 1 none Mattermost DB SELECT id , createat , updateat , deleteat , username FROM public.posts 0 N N N N String normal id 32 -1 Input user id , . none N Y 0 N N N en_US Europe/Berlin N Integer normal createat 15 0 Input user createat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Integer normal updateat 15 0 Input user updateat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N Integer normal deleteat 15 0 Input user deleteat ####0;-####0 , . none N Y 0 N N N en_US Europe/Berlin N String normal username 64 -1 Input user username , . none N Y 0 N N N en_US Europe/Berlin N 128 192 Y Insert / update boolean InsertUpdate Y 1 none Data Warehouse 100 N llua_mattermost_message fact_message
messageID id = thread_id thread_id Y channel_id channel_id Y create_date_id create_date_id Y create_time_id create_time_id Y delete_date_id delete_date_id Y delete_time_id delete_time_id Y fileinfo_id fileinfo_id Y hasreactions hasreactions Y ispinned ispinned Y team_id team_id Y user_id user_id Y id messageID N 688 3984 Y Maintable Dummy N 1 none 688 2048 Y Merge join 4 MergeJoin Y 1 none INNER 512 1200 N Merge join postID - postid MergeJoin Y 1 none LEFT OUTER Sort rows postID Sort rows fileinfo postID postid 688 1296 Y Merge join postID - postid 2 MergeJoin N 1 none LEFT OUTER Sort rows postID 2 Sort rows threads postID postid 688 1648 Y Merge join posts & user MergeJoin N 1 none LEFT OUTER Sort rows posts Sort rows user userid id 688 192 Y Merge join posts & user & channels MergeJoin Y 1 none LEFT OUTER Sort rows posts & user Sort rows channels channelid channelID 688 640 Y Merge join teamid - id MergeJoin Y 1 none LEFT OUTER Sort rows teamid Sort rows teams teamid id 688 992 Y Select values 7 SelectValues Y 1 none N 512 1936 N Select values channels SelectValues Y 1 none id channelID Y createat updateat deleteat type totalmsgcount extraupdateat creatorid schemeid groupconstrained shared totalmsgcountroot 272 640 Y Select values fileinfo SelectValues Y 1 none id fileInfoID Y creatorid createat updateat deleteat mimetype 304 1296 Y Select values posts SelectValues Y 1 none id postID Y rootid originalid type updateat 256 80 Y Select values posts & user SelectValues Y 1 none Y id deleteat_1 688 384 Y Select values remove channelID_1 SelectValues Y 1 none Y channelID_1 688 768 Y Select values remove id, rename name_1 to teamname SelectValues Y 1 none name_1 teamname Y id 688 1088 Y Select values remove postid_1 SelectValues Y 1 none Y postid_1 688 1424 Y Select values remove unnecessary data SelectValues Y 1 none Y createat channelid fileInfoID postid_1 userid deleteat lastpostat teamid lastreplyat editat 688 1936 Y Select values rename postID to messageID and name to channelname SelectValues Y 1 none postID messageID name channelname Y 688 1856 Y Select values teams SelectValues N 1 none N createat updateat deleteat displayname type companyname allowopeninvite lastteamiconupdate schemeid groupconstrained 288 992 Y Select values threads SelectValues Y 1 none Y channelid 304 1648 Y Select values user SelectValues Y 1 none N createat updateat 256 192 Y Select values: rename id to channel_id SelectValues Y 1 none id channel_id Y 688 3008 Y Select values: rename id to create_date_id SelectValues Y 1 none id create_date_id Y 688 2640 Y Select values: rename id to create_time_id SelectValues Y 1 none id create_time_id Y 688 2304 Y Select values: rename id to delete_date_id SelectValues Y 1 none id delete_date_id Y 688 2800 Y Select values: rename id to delete_time_id SelectValues Y 1 none id delete_time_id Y 688 2464 Y Select values: rename id to fileinfo_id SelectValues Y 1 none id fileinfo_id Y 688 3200 Y Select values: rename id to team_id SelectValues Y 1 none id team_id Y 688 3600 Y Select values: rename id to thread_id SelectValues Y 1 none id thread_id Y 688 3792 Y Select values: rename id to user_id SelectValues Y 1 none id user_id Y 688 3392 Y Sort rows channels SortRows N 1 none %%java.io.tmpdir%% out 1000000 N N channelID Y N N 0 N 432 640 Y Sort rows fileinfo SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N postid Y N N 0 N 432 1296 Y Sort rows postID SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N postID Y N N 0 N 688 1184 Y Sort rows postID 2 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N postID Y N N 0 N 688 1536 Y Sort rows posts SortRows N 1 none %%java.io.tmpdir%% out 1000000 N N userid Y N N 0 N 416 80 Y Sort rows posts & user SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N channelid Y N N 0 N 688 496 Y Sort rows teamid SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N teamid Y N N 0 N 688 864 Y Sort rows teams SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N id Y N N 0 N 432 992 Y Sort rows threads SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N postid Y N N 0 N 432 1648 Y Sort rows user SortRows N 1 none %%java.io.tmpdir%% out 1000000 N N id Y N N 0 N 416 192 Y Text file output: CSV for PM TextFileOutput Y 1 none ; " N N
Y
N
UNIX None UTF-8 N N ${DI_HOME}/csv/mattermost_message N Y csv N N N N N Y -yyyy-MM-dd-HH-mm-ss Y N N 1152 2320 Y N