Join Percona’s MySQL Practice Manager Kenny Gryp and QA Engineer, Ramesh Sivaraman as they present Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication on Wednesday, June 21, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7).
DATA breas.art; INFILE '/apps/dataapps15/projects/dinhch/artfile.txt' DELIMITER=',' dsd lrecl=400 pad missover; INPUT ICN :$14. ICN_VRSN :8. DOC_ID :$15. ADJKEY :$8. TTL_CHRG :13.2 PDATE :$8. ADJ_TYPE_CD :$2. ADJ_RSN_CD :$3. UPD_USER :$8. TTL_PAID_AMNT :13.2 FUND_CODE :$13. FUND :$154.; Group by the ADJKEY , count the ICN and sum up the TTL_Paid_amnt Print it out example, the result file would be ADJKEY Count Sum
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.