2019-02-05 02:09:12 
2019-02-05 02:09:12 R version 3.5.1 (2018-07-02) -- "Feather Spray"
2019-02-05 02:09:12 Copyright (C) 2018 The R Foundation for Statistical Computing
2019-02-05 02:09:12 Platform: x86_64-pc-linux-gnu (64-bit)
2019-02-05 02:09:12 
2019-02-05 02:09:12 R is free software and comes with ABSOLUTELY NO WARRANTY.
2019-02-05 02:09:12 You are welcome to redistribute it under certain conditions.
2019-02-05 02:09:12 Type 'license()' or 'licence()' for distribution details.
2019-02-05 02:09:12 
2019-02-05 02:09:12   Natural language support but running in an English locale
2019-02-05 02:09:12 
2019-02-05 02:09:12 R is a collaborative project with many contributors.
2019-02-05 02:09:12 Type 'contributors()' for more information and
2019-02-05 02:09:12 'citation()' on how to cite R or R packages in publications.
2019-02-05 02:09:12 
2019-02-05 02:09:12 Type 'demo()' for some demos, 'help()' for on-line help, or
2019-02-05 02:09:12 'help.start()' for an HTML browser interface to help.
2019-02-05 02:09:12 Type 'q()' to quit R.
2019-02-05 02:09:12 
2019-02-05 02:09:12 > setwd( Sys.getenv( "RWD" ) )
2019-02-05 02:09:12 > 
2019-02-05 02:09:12 > machine_specific_replacements <- 
2019-02-05 02:09:12 + 	list( 
2019-02-05 02:09:12 + 		
2019-02-05 02:09:12 + 		# replace the folder path on macnix
2019-02-05 02:09:12 + 		c( 'path.expand( \"~\" ) , \"BSAPUF\"' , paste0( '"' , getwd() , '"' ) ) ,
2019-02-05 02:09:12 + 		
2019-02-05 02:09:12 + 		# change other things in the script to be run
2019-02-05 02:09:12 + 		c( "hello" , "howdy" )
2019-02-05 02:09:12 + 		
2019-02-05 02:09:12 + 	)
2019-02-05 02:09:12 > 
2019-02-05 02:09:12 > source( lodown::syntaxtractor( "bsapuf" , replacements = machine_specific_replacements , setup_test = "setup" ) , echo = TRUE )
2019-02-05 02:09:14 
2019-02-05 02:09:14 > library(lodown)
2019-02-05 02:09:14 
2019-02-05 02:09:14 > lodown("bsapuf", output_dir = file.path("/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937"))
2019-02-05 02:09:14 building catalog for bsapuf
2019-02-05 02:09:14 
2019-02-05 02:09:18 locally downloading bsapuf
2019-02-05 02:09:18 
2019-02-05 02:09:25 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2008_BSA_Inpatient_Claims_PUF.zip'
2019-02-05 02:09:25 cached in
2019-02-05 02:09:25 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/4fe970af6b1c8e14d8831df84d666cd8.Rcache'
2019-02-05 02:09:25 copying to
2019-02-05 02:09:25 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:09:25 
2019-02-05 02:09:26 QQ: 'START TRANSACTION'
2019-02-05 02:09:26 II: Finished in 0s
2019-02-05 02:09:26 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:09:26 II: Finished in 0.01s
2019-02-05 02:09:27 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:09:27 II: Finished in 0s
2019-02-05 02:09:27 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:09:27 II: Finished in 0s
2019-02-05 02:09:27 QQ: 'CREATE TABLE bsa_inpatient_claims_2008 (ip_clm_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, ip_clm_base_drg_cd INTEGER, ip_clm_icd9_prcdr_cd INTEGER, ip_clm_days_cd INTEGER, ip_drg_quint_pmt_avg INTEGER, ip_drg_quint_pmt_cd INTEGER)'
2019-02-05 02:09:27 II: Finished in 0s
2019-02-05 02:09:27 QQ: 'COPY OFFSET 2 INTO bsa_inpatient_claims_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Inpatient_Claims_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:09:27 II: Finished in 0.48s
2019-02-05 02:09:27 QQ: 'SELECT COUNT(*) FROM bsa_inpatient_claims_2008'
2019-02-05 02:09:27 II: Finished in 0s
2019-02-05 02:09:27 QQ: 'COMMIT'
2019-02-05 02:09:32 II: Finished in 4.36s
2019-02-05 02:09:32 QQ: 'SELECT COUNT(*) FROM bsa_inpatient_claims_2008'
2019-02-05 02:09:32 II: Finished in 0.03s
2019-02-05 02:09:32 bsapuf catalog entry 1 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:09:32 
2019-02-05 02:12:40 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_DME_PUF.zip'
2019-02-05 02:12:40 cached in
2019-02-05 02:12:40 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/ddaebdb6fd5ab66e19655b97a73a4344.Rcache'
2019-02-05 02:12:40 copying to
2019-02-05 02:12:40 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:12:40 
2019-02-05 02:12:40 QQ: 'START TRANSACTION'
2019-02-05 02:12:40 II: Finished in 0s
2019-02-05 02:12:40 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:12:40 II: Finished in 0s
2019-02-05 02:12:40 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:12:40 II: Finished in 0s
2019-02-05 02:12:40 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:12:40 II: Finished in 0s
2019-02-05 02:12:40 QQ: 'CREATE TABLE dme_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, dme_line_icd_dgns_cd STRING, dme_line_hcpcs_cd STRING, dme_line_srvc_cnt INTEGER, dme_line_pmt_amt INTEGER, line_item_cnt INTEGER)'
2019-02-05 02:12:40 II: Finished in 0s
2019-02-05 02:12:40 QQ: 'COPY OFFSET 2 INTO dme_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_BSA_DME_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:12:40 II: Finished in 0.15s
2019-02-05 02:12:40 QQ: 'SELECT COUNT(*) FROM dme_2010'
2019-02-05 02:12:40 II: Finished in 0s
2019-02-05 02:12:40 QQ: 'COMMIT'
2019-02-05 02:12:42 II: Finished in 2.2s
2019-02-05 02:12:42 QQ: 'SELECT COUNT(*) FROM dme_2010'
2019-02-05 02:12:42 II: Finished in 0.01s
2019-02-05 02:12:42 bsapuf catalog entry 2 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:12:42 
2019-02-05 02:13:45 'https://downloads.cms.gov/BSAPUF/2008_BSA_DME_Line_Items_PUF.zip'
2019-02-05 02:13:45 cached in
2019-02-05 02:13:45 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/6a4e93b3bea886aae3dc60944eb9c9c7.Rcache'
2019-02-05 02:13:45 copying to
2019-02-05 02:13:45 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:13:45 
2019-02-05 02:13:48 QQ: 'START TRANSACTION'
2019-02-05 02:13:48 II: Finished in 0s
2019-02-05 02:13:48 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:13:48 II: Finished in 0s
2019-02-05 02:13:48 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:13:48 II: Finished in 0s
2019-02-05 02:13:48 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:13:48 II: Finished in 0s
2019-02-05 02:13:48 QQ: 'CREATE TABLE bsa_dme_line_items_2008 (dme_line_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, dme_line_icd9_dgns_cd STRING, dme_line_hcpcs_cd STRING, dme_line_srvc_cnt INTEGER, dme_line_pmt_amt INTEGER)'
2019-02-05 02:13:48 II: Finished in 0s
2019-02-05 02:13:48 QQ: 'COPY OFFSET 2 INTO bsa_dme_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_DME_Line_Items_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:13:52 II: Finished in 3.45s
2019-02-05 02:13:52 QQ: 'SELECT COUNT(*) FROM bsa_dme_line_items_2008'
2019-02-05 02:13:52 II: Finished in 0s
2019-02-05 02:13:52 QQ: 'COMMIT'
2019-02-05 02:14:16 II: Finished in 24.34s
2019-02-05 02:14:16 QQ: 'SELECT COUNT(*) FROM bsa_dme_line_items_2008'
2019-02-05 02:14:16 II: Finished in 0.02s
2019-02-05 02:14:16 bsapuf catalog entry 3 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:14:16 
2019-02-05 02:15:20 'https://downloads.cms.gov/BSAPUF/2008_BSA_PartD_Events_PUF_1.zip'
2019-02-05 02:15:20 cached in
2019-02-05 02:15:20 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/eb75bea32b9a89ccab5b078f55748832.Rcache'
2019-02-05 02:15:20 copying to
2019-02-05 02:15:20 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:15:20 
2019-02-05 02:15:27 QQ: 'START TRANSACTION'
2019-02-05 02:15:27 II: Finished in 0s
2019-02-05 02:15:27 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:15:27 II: Finished in 0.01s
2019-02-05 02:15:27 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:15:27 II: Finished in 0s
2019-02-05 02:15:27 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:15:27 II: Finished in 0s
2019-02-05 02:15:27 QQ: 'CREATE TABLE bsa_partd_events_2008 (pde_event_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, pde_drug_cd INTEGER, pde_drug_str_cd INTEGER, pde_drug_str_units_cd INTEGER, pde_drug_dose_cd INTEGER, pde_drug_class_cd INTEGER, pde_drug_qty_dis INTEGER, pde_drug_day_sply_cd INTEGER, pde_drug_cost INTEGER, pde_drug_pat_pay_cd INTEGER, pde_drug_type_cd INTEGER)'
2019-02-05 02:15:27 II: Finished in 0s
2019-02-05 02:15:27 QQ: 'COPY OFFSET 2 INTO bsa_partd_events_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_PartD_Events_PUF_1.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:15:40 II: Finished in 13.23s
2019-02-05 02:15:40 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 02:15:40 II: Finished in 0s
2019-02-05 02:15:40 QQ: 'COMMIT'
2019-02-05 02:16:10 II: Finished in 29.81s
2019-02-05 02:16:10 bsapuf catalog entry 4 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:16:10 
2019-02-05 02:16:58 'https://downloads.cms.gov/BSAPUF/2008_BSA_PartD_Events_PUF_2.zip'
2019-02-05 02:16:58 cached in
2019-02-05 02:16:58 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/b4c2a9af16f3b074e359b12b9f5aa442.Rcache'
2019-02-05 02:16:58 copying to
2019-02-05 02:16:58 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:16:58 
2019-02-05 02:17:06 QQ: 'START TRANSACTION'
2019-02-05 02:17:06 II: Finished in 0s
2019-02-05 02:17:06 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:17:06 II: Finished in 0s
2019-02-05 02:17:06 QQ: 'COPY OFFSET 2 INTO bsa_partd_events_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_PartD_Events_PUF_2.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:17:19 II: Finished in 13.34s
2019-02-05 02:17:19 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 02:17:21 II: Finished in 1.64s
2019-02-05 02:17:21 QQ: 'COMMIT'
2019-02-05 02:17:27 II: Finished in 5.57s
2019-02-05 02:17:27 bsapuf catalog entry 5 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:17:27 
2019-02-05 02:18:51 'https://downloads.cms.gov/BSAPUF/2008_BSA_PartD_Events_PUF_3.zip'
2019-02-05 02:18:51 cached in
2019-02-05 02:18:51 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/23c544e75141836bf2a814a415609baa.Rcache'
2019-02-05 02:18:51 copying to
2019-02-05 02:18:51 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:18:51 
2019-02-05 02:18:58 QQ: 'START TRANSACTION'
2019-02-05 02:18:58 II: Finished in 0s
2019-02-05 02:18:58 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:18:58 II: Finished in 0s
2019-02-05 02:18:58 QQ: 'COPY OFFSET 2 INTO bsa_partd_events_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_PartD_Events_PUF_3.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:19:11 II: Finished in 13.06s
2019-02-05 02:19:11 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 02:19:15 II: Finished in 3.59s
2019-02-05 02:19:15 QQ: 'COMMIT'
2019-02-05 02:19:30 II: Finished in 15.26s
2019-02-05 02:19:30 bsapuf catalog entry 6 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:19:30 
2019-02-05 02:20:52 'https://downloads.cms.gov/BSAPUF/2008_BSA_PartD_Events_PUF_4.zip'
2019-02-05 02:20:52 cached in
2019-02-05 02:20:52 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/d273fc3da91152fdc665fecfba2cdbba.Rcache'
2019-02-05 02:20:52 copying to
2019-02-05 02:20:52 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:20:52 
2019-02-05 02:21:22 QQ: 'START TRANSACTION'
2019-02-05 02:21:22 II: Finished in 0s
2019-02-05 02:21:22 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:21:22 II: Finished in 0s
2019-02-05 02:21:22 QQ: 'COPY OFFSET 2 INTO bsa_partd_events_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_PartD_Events_PUF_4.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:21:34 II: Finished in 11.85s
2019-02-05 02:21:34 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 02:21:36 II: Finished in 1.88s
2019-02-05 02:21:36 QQ: 'COMMIT'
2019-02-05 02:22:39 II: Finished in 1.06s
2019-02-05 02:22:43 bsapuf catalog entry 7 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:22:43 
2019-02-05 02:31:06 'https://downloads.cms.gov/BSAPUF/2008_BSA_PartD_Events_PUF_5.zip'
2019-02-05 02:31:07 cached in
2019-02-05 02:31:07 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/c781b9d1af3e12b9ef5bf6cd7146e243.Rcache'
2019-02-05 02:31:07 copying to
2019-02-05 02:31:07 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:31:07 
2019-02-05 02:31:48 QQ: 'START TRANSACTION'
2019-02-05 02:31:48 II: Finished in 0s
2019-02-05 02:31:48 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:31:48 II: Finished in 0s
2019-02-05 02:31:48 QQ: 'COPY OFFSET 2 INTO bsa_partd_events_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_PartD_Events_PUF_5.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:32:01 II: Finished in 12.89s
2019-02-05 02:32:01 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 02:32:03 II: Finished in 2.09s
2019-02-05 02:32:03 QQ: 'COMMIT'
2019-02-05 02:32:10 II: Finished in 6.78s
2019-02-05 02:32:10 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 02:32:10 II: Finished in 0s
2019-02-05 02:32:10 bsapuf catalog entry 8 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:32:10 
2019-02-05 02:40:30 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_BSA_Hospice_Beneficiary_PUF.zip'
2019-02-05 02:40:30 cached in
2019-02-05 02:40:30 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/99c618bc26e7c356ace9f6acdca1772b.Rcache'
2019-02-05 02:40:30 copying to
2019-02-05 02:40:30 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:40:30 
2019-02-05 02:40:30 QQ: 'START TRANSACTION'
2019-02-05 02:40:30 II: Finished in 0s
2019-02-05 02:40:30 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:40:30 II: Finished in 0.16s
2019-02-05 02:40:30 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:40:30 II: Finished in 0s
2019-02-05 02:40:30 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:40:30 II: Finished in 0s
2019-02-05 02:40:30 QQ: 'CREATE TABLE bsa_hospice_beneficiary_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, hospc_deceased_cd INTEGER, hospc_dx_cd INTEGER, hospc_cancer_cd INTEGER, hospc_days_cd INTEGER, hospc_pmt_amt INTEGER, bene_cnt INTEGER)'
2019-02-05 02:40:30 II: Finished in 0s
2019-02-05 02:40:30 QQ: 'COPY OFFSET 2 INTO bsa_hospice_beneficiary_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_BSA_Hospice_Beneficiary_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:40:31 II: Finished in 0.06s
2019-02-05 02:40:31 QQ: 'SELECT COUNT(*) FROM bsa_hospice_beneficiary_2010'
2019-02-05 02:40:31 II: Finished in 0s
2019-02-05 02:40:31 QQ: 'COMMIT'
2019-02-05 02:40:31 II: Finished in 0.15s
2019-02-05 02:40:31 QQ: 'SELECT COUNT(*) FROM bsa_hospice_beneficiary_2010'
2019-02-05 02:40:31 II: Finished in 0s
2019-02-05 02:40:31 bsapuf catalog entry 9 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:40:31 
2019-02-05 02:43:56 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2008_BSA_Hospice_Beneficiary_PUF.zip'
2019-02-05 02:43:56 cached in
2019-02-05 02:43:56 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/b5121d5ff46042ffb30b0f59c4f5809a.Rcache'
2019-02-05 02:43:56 copying to
2019-02-05 02:43:56 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:43:56 
2019-02-05 02:43:56 QQ: 'START TRANSACTION'
2019-02-05 02:43:56 II: Finished in 0s
2019-02-05 02:43:56 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:43:58 II: Finished in 2.41s
2019-02-05 02:43:58 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:43:58 II: Finished in 0s
2019-02-05 02:43:58 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:43:58 II: Finished in 0s
2019-02-05 02:43:58 QQ: 'CREATE TABLE bsa_hospice_beneficiary_2008 (hospc_bene_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, hospc_deceased_cd INTEGER, hospc_dx_cd INTEGER, hospc_cancer_cd INTEGER, hospc_days_cd INTEGER, hospc_pmt_amt INTEGER)'
2019-02-05 02:43:58 II: Finished in 0s
2019-02-05 02:43:58 QQ: 'COPY OFFSET 2 INTO bsa_hospice_beneficiary_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Hospice_Beneficiary_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:43:58 II: Finished in 0.11s
2019-02-05 02:43:58 QQ: 'SELECT COUNT(*) FROM bsa_hospice_beneficiary_2008'
2019-02-05 02:43:58 II: Finished in 0s
2019-02-05 02:43:58 QQ: 'COMMIT'
2019-02-05 02:44:04 II: Finished in 5.77s
2019-02-05 02:44:04 QQ: 'SELECT COUNT(*) FROM bsa_hospice_beneficiary_2008'
2019-02-05 02:44:04 II: Finished in 0.01s
2019-02-05 02:44:04 bsapuf catalog entry 10 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:44:04 
2019-02-05 02:45:32 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_Carrier_PUF.zip'
2019-02-05 02:45:32 cached in
2019-02-05 02:45:32 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/c599535f40f2ee1421797225cd0fa17f.Rcache'
2019-02-05 02:45:32 copying to
2019-02-05 02:45:32 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:45:32 
2019-02-05 02:45:37 QQ: 'START TRANSACTION'
2019-02-05 02:45:37 II: Finished in 0s
2019-02-05 02:45:37 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:45:37 II: Finished in 0s
2019-02-05 02:45:37 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:45:37 II: Finished in 0s
2019-02-05 02:45:37 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:45:37 II: Finished in 0s
2019-02-05 02:45:37 QQ: 'CREATE TABLE carrier_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, car_line_icd9_dgns_cd STRING, car_line_hcpcs_cd STRING, car_line_betos_cd STRING, car_line_srvc_cnt INTEGER, car_line_prvdr_type_cd INTEGER, car_line_cms_type_srvc_cd STRING, car_line_place_of_srvc_cd INTEGER, car_hcps_pmt_amt INTEGER, car_line_cnt INTEGER)'
2019-02-05 02:45:37 II: Finished in 0s
2019-02-05 02:45:37 QQ: 'COPY OFFSET 2 INTO carrier_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_BSA_Carrier_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:45:39 II: Finished in 2.55s
2019-02-05 02:45:39 QQ: 'SELECT COUNT(*) FROM carrier_2010'
2019-02-05 02:45:39 II: Finished in 0s
2019-02-05 02:45:39 QQ: 'COMMIT'
2019-02-05 02:46:01 II: Finished in 21.31s
2019-02-05 02:46:01 QQ: 'SELECT COUNT(*) FROM carrier_2010'
2019-02-05 02:46:01 II: Finished in 0.02s
2019-02-05 02:46:01 bsapuf catalog entry 11 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:46:01 
2019-02-05 02:47:36 'https://downloads.cms.gov/BSAPUF/2008_BSA_Carrier_Line_Items_PUF_1.zip'
2019-02-05 02:47:36 cached in
2019-02-05 02:47:36 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/acb84dda9d3ffe3d6064c578d3e9b2ef.Rcache'
2019-02-05 02:47:36 copying to
2019-02-05 02:47:36 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:47:36 
2019-02-05 02:47:42 QQ: 'START TRANSACTION'
2019-02-05 02:47:42 II: Finished in 0s
2019-02-05 02:47:42 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:47:42 II: Finished in 0s
2019-02-05 02:47:42 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:47:42 II: Finished in 0s
2019-02-05 02:47:42 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:47:42 II: Finished in 0s
2019-02-05 02:47:42 QQ: 'CREATE TABLE bsa_carrier_line_items_2008 (car_line_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, car_line_icd9_dgns_cd STRING, car_line_hcpcs_cd STRING, car_line_betos_cd STRING, car_line_srvc_cnt INTEGER, car_line_prvdr_type_cd INTEGER, car_line_cms_type_srvc_cd STRING, car_line_place_of_srvc_cd INTEGER, car_hcpcs_pmt_amt INTEGER)'
2019-02-05 02:47:42 II: Finished in 0s
2019-02-05 02:47:42 QQ: 'COPY OFFSET 2 INTO bsa_carrier_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Carrier_Line_Items_PUF_1.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:47:51 II: Finished in 9.5s
2019-02-05 02:47:51 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 02:47:51 II: Finished in 0.01s
2019-02-05 02:47:51 QQ: 'COMMIT'
2019-02-05 02:48:47 II: Finished in 55.75s
2019-02-05 02:48:47 bsapuf catalog entry 12 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:48:47 
2019-02-05 02:51:29 'https://downloads.cms.gov/BSAPUF/2008_BSA_Carrier_Line_Items_PUF_2.zip'
2019-02-05 02:51:29 cached in
2019-02-05 02:51:29 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/410ff262450e2f7121735cace015aec6.Rcache'
2019-02-05 02:51:29 copying to
2019-02-05 02:51:29 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 02:51:29 
2019-02-05 02:51:39 QQ: 'START TRANSACTION'
2019-02-05 02:51:39 II: Finished in 0s
2019-02-05 02:51:39 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 02:51:39 II: Finished in 0s
2019-02-05 02:51:39 QQ: 'COPY OFFSET 2 INTO bsa_carrier_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Carrier_Line_Items_PUF_2.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 02:51:47 II: Finished in 8.54s
2019-02-05 02:51:47 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 02:51:49 II: Finished in 1.23s
2019-02-05 02:51:49 QQ: 'COMMIT'
2019-02-05 02:52:11 II: Finished in 22.51s
2019-02-05 02:52:11 bsapuf catalog entry 13 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 02:52:11 
2019-02-05 03:02:15 'https://downloads.cms.gov/BSAPUF/2008_BSA_Carrier_Line_Items_PUF_3.zip'
2019-02-05 03:02:15 cached in
2019-02-05 03:02:15 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/d619ee35a2e3dc548663e3178c7f2eb1.Rcache'
2019-02-05 03:02:15 copying to
2019-02-05 03:02:15 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:02:15 
2019-02-05 03:02:23 QQ: 'START TRANSACTION'
2019-02-05 03:02:23 II: Finished in 0s
2019-02-05 03:02:23 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:02:23 II: Finished in 0s
2019-02-05 03:02:23 QQ: 'COPY OFFSET 2 INTO bsa_carrier_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Carrier_Line_Items_PUF_3.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:02:31 II: Finished in 8.56s
2019-02-05 03:02:31 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 03:02:33 II: Finished in 1.3s
2019-02-05 03:02:33 QQ: 'COMMIT'
2019-02-05 03:02:50 II: Finished in 17.39s
2019-02-05 03:02:50 bsapuf catalog entry 14 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:02:50 
2019-02-05 03:18:47 'https://downloads.cms.gov/BSAPUF/2008_BSA_Carrier_Line_Items_PUF_4.zip'
2019-02-05 03:18:47 cached in
2019-02-05 03:18:47 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/a82c908fa037fcccf8accef091321e59.Rcache'
2019-02-05 03:18:47 copying to
2019-02-05 03:18:47 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:18:47 
2019-02-05 03:19:24 QQ: 'START TRANSACTION'
2019-02-05 03:19:24 II: Finished in 0s
2019-02-05 03:19:24 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:19:24 II: Finished in 0s
2019-02-05 03:19:24 QQ: 'COPY OFFSET 2 INTO bsa_carrier_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Carrier_Line_Items_PUF_4.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:19:33 II: Finished in 9.09s
2019-02-05 03:19:33 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 03:19:34 II: Finished in 1.44s
2019-02-05 03:19:34 QQ: 'COMMIT'
2019-02-05 03:20:41 II: Finished in 1.11s
2019-02-05 03:20:41 bsapuf catalog entry 15 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:20:41 
2019-02-05 03:25:38 'https://downloads.cms.gov/BSAPUF/2008_BSA_Carrier_Line_Items_PUF_5.zip'
2019-02-05 03:25:38 cached in
2019-02-05 03:25:38 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/fafe7e42632ea662b3bc1e992086a4fd.Rcache'
2019-02-05 03:25:38 copying to
2019-02-05 03:25:38 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:25:38 
2019-02-05 03:25:56 QQ: 'START TRANSACTION'
2019-02-05 03:25:56 II: Finished in 0s
2019-02-05 03:25:56 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:25:56 II: Finished in 0s
2019-02-05 03:25:56 QQ: 'COPY OFFSET 2 INTO bsa_carrier_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Carrier_Line_Items_PUF_5.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:26:09 II: Finished in 13.42s
2019-02-05 03:26:09 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 03:26:11 II: Finished in 1.97s
2019-02-05 03:26:11 QQ: 'COMMIT'
2019-02-05 03:26:58 II: Finished in 46.6s
2019-02-05 03:26:58 bsapuf catalog entry 16 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:26:58 
2019-02-05 03:39:10 'https://downloads.cms.gov/BSAPUF/2008_BSA_Carrier_Line_Items_PUF_6.zip'
2019-02-05 03:39:10 cached in
2019-02-05 03:39:10 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/1c50d0d7805032c66de6df50ebd7a01e.Rcache'
2019-02-05 03:39:10 copying to
2019-02-05 03:39:10 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:39:10 
2019-02-05 03:39:17 QQ: 'START TRANSACTION'
2019-02-05 03:39:17 II: Finished in 0s
2019-02-05 03:39:17 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:39:17 II: Finished in 0s
2019-02-05 03:39:17 QQ: 'COPY OFFSET 2 INTO bsa_carrier_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Carrier_Line_Items_PUF_6.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:39:28 II: Finished in 11.67s
2019-02-05 03:39:28 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 03:39:30 II: Finished in 2.07s
2019-02-05 03:39:30 QQ: 'COMMIT'
2019-02-05 03:39:50 II: Finished in 19.24s
2019-02-05 03:39:50 bsapuf catalog entry 17 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:39:50 
2019-02-05 03:40:46 'https://downloads.cms.gov/BSAPUF/2008_BSA_Carrier_Line_Items_PUF_7.zip'
2019-02-05 03:40:46 cached in
2019-02-05 03:40:46 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/48e85dd865252a077c61fd06789d6089.Rcache'
2019-02-05 03:40:46 copying to
2019-02-05 03:40:46 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:40:46 
2019-02-05 03:40:53 QQ: 'START TRANSACTION'
2019-02-05 03:40:53 II: Finished in 0s
2019-02-05 03:40:53 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:40:53 II: Finished in 0s
2019-02-05 03:40:53 QQ: 'COPY OFFSET 2 INTO bsa_carrier_line_items_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Carrier_Line_Items_PUF_7.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:41:03 II: Finished in 10.62s
2019-02-05 03:41:03 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 03:41:05 II: Finished in 2.24s
2019-02-05 03:41:05 QQ: 'COMMIT'
2019-02-05 03:41:28 II: Finished in 22.8s
2019-02-05 03:41:28 QQ: 'SELECT COUNT(*) FROM bsa_carrier_line_items_2008'
2019-02-05 03:41:28 II: Finished in 0s
2019-02-05 03:41:28 bsapuf catalog entry 18 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:41:28 
2019-02-05 03:43:13 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_BSA_HHA_Beneficiary_PUF.zip'
2019-02-05 03:43:13 cached in
2019-02-05 03:43:13 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/034d24e229adb62fd9a0173e85791a89.Rcache'
2019-02-05 03:43:13 copying to
2019-02-05 03:43:13 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:43:13 
2019-02-05 03:43:13 QQ: 'START TRANSACTION'
2019-02-05 03:43:13 II: Finished in 0s
2019-02-05 03:43:13 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:43:13 II: Finished in 0.12s
2019-02-05 03:43:13 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:43:13 II: Finished in 0s
2019-02-05 03:43:13 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:43:13 II: Finished in 0s
2019-02-05 03:43:13 QQ: 'CREATE TABLE bsa_hha_beneficiary_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, hha_adm_cd INTEGER, hha_ther_vst_cd INTEGER, hha_snc_vst_cd INTEGER, hha_hha_vst_cd INTEGER, hha_pmt_amt INTEGER, bene_cnt INTEGER)'
2019-02-05 03:43:13 II: Finished in 0s
2019-02-05 03:43:13 QQ: 'COPY OFFSET 2 INTO bsa_hha_beneficiary_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_BSA_HHA_Beneficiary_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:43:13 II: Finished in 0.07s
2019-02-05 03:43:13 QQ: 'SELECT COUNT(*) FROM bsa_hha_beneficiary_2010'
2019-02-05 03:43:13 II: Finished in 0s
2019-02-05 03:43:13 QQ: 'COMMIT'
2019-02-05 03:43:13 II: Finished in 0.16s
2019-02-05 03:43:13 QQ: 'SELECT COUNT(*) FROM bsa_hha_beneficiary_2010'
2019-02-05 03:43:13 II: Finished in 0s
2019-02-05 03:43:13 bsapuf catalog entry 19 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:43:13 
2019-02-05 03:44:09 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2008_BSA_HHA_Beneficiary_PUF.zip'
2019-02-05 03:44:09 cached in
2019-02-05 03:44:09 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/5c1409dbbfda03860d1aa0f647b2fcb3.Rcache'
2019-02-05 03:44:09 copying to
2019-02-05 03:44:09 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:44:09 
2019-02-05 03:44:10 QQ: 'START TRANSACTION'
2019-02-05 03:44:10 II: Finished in 0s
2019-02-05 03:44:10 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:44:10 II: Finished in 0.06s
2019-02-05 03:44:10 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:44:10 II: Finished in 0.01s
2019-02-05 03:44:10 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:44:10 II: Finished in 0s
2019-02-05 03:44:10 QQ: 'CREATE TABLE bsa_hha_beneficiary_2008 (hha_bene_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, hha_adm_cd INTEGER, hha_ther_vst_cd INTEGER, hha_snc_vst_cd INTEGER, hha_hha_vst_cd INTEGER, hha_pmt_amt INTEGER)'
2019-02-05 03:44:10 II: Finished in 0s
2019-02-05 03:44:10 QQ: 'COPY OFFSET 2 INTO bsa_hha_beneficiary_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_HHA_Beneficiary_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:44:10 II: Finished in 0.13s
2019-02-05 03:44:10 QQ: 'SELECT COUNT(*) FROM bsa_hha_beneficiary_2008'
2019-02-05 03:44:10 II: Finished in 0s
2019-02-05 03:44:10 QQ: 'COMMIT'
2019-02-05 03:44:10 II: Finished in 0.26s
2019-02-05 03:44:10 QQ: 'SELECT COUNT(*) FROM bsa_hha_beneficiary_2008'
2019-02-05 03:44:10 II: Finished in 0s
2019-02-05 03:44:10 bsapuf catalog entry 20 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:44:10 
2019-02-05 03:46:04 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_BSA_Outpatient_PUF.zip'
2019-02-05 03:46:04 cached in
2019-02-05 03:46:04 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/35026c5634e935db9d30f68094866bd2.Rcache'
2019-02-05 03:46:04 copying to
2019-02-05 03:46:04 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:46:04 
2019-02-05 03:46:05 QQ: 'START TRANSACTION'
2019-02-05 03:46:05 II: Finished in 0s
2019-02-05 03:46:05 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:46:05 II: Finished in 0s
2019-02-05 03:46:05 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:46:05 II: Finished in 0s
2019-02-05 03:46:05 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:46:05 II: Finished in 0s
2019-02-05 03:46:05 QQ: 'CREATE TABLE bsa_outpatient_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, op_clm_icd9_diag_cd STRING, op_hcpcd_cd STRING, op_hcpcs_unit_cnt INTEGER, op_hcpcs_pmt_amt INTEGER, proc_cnt INTEGER)'
2019-02-05 03:46:05 II: Finished in 0s
2019-02-05 03:46:05 QQ: 'COPY OFFSET 2 INTO bsa_outpatient_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_BSA_Outpatient_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:46:06 II: Finished in 0.85s
2019-02-05 03:46:06 QQ: 'SELECT COUNT(*) FROM bsa_outpatient_2010'
2019-02-05 03:46:06 II: Finished in 0s
2019-02-05 03:46:06 QQ: 'COMMIT'
2019-02-05 03:46:34 II: Finished in 28.07s
2019-02-05 03:46:34 QQ: 'SELECT COUNT(*) FROM bsa_outpatient_2010'
2019-02-05 03:46:34 II: Finished in 0.01s
2019-02-05 03:46:34 bsapuf catalog entry 21 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:46:34 
2019-02-05 03:48:02 'https://downloads.cms.gov/BSAPUF/2008_BSA_Outpatient_Procedures_PUF_1.zip'
2019-02-05 03:48:02 cached in
2019-02-05 03:48:02 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/fcea1ec212517c3472fb61af92848bfc.Rcache'
2019-02-05 03:48:02 copying to
2019-02-05 03:48:02 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:48:02 
2019-02-05 03:48:08 QQ: 'START TRANSACTION'
2019-02-05 03:48:08 II: Finished in 0s
2019-02-05 03:48:08 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:48:08 II: Finished in 0.01s
2019-02-05 03:48:08 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:48:08 II: Finished in 0s
2019-02-05 03:48:08 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:48:08 II: Finished in 0s
2019-02-05 03:48:08 QQ: 'CREATE TABLE bsa_outpatient_procedures_2008 (op_proc_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, op_clm_icd9_diag_cd STRING, op_hcpcs_cd STRING, op_hcpcs_unit_cnt INTEGER, op_hcpcs_pmt_amt INTEGER)'
2019-02-05 03:48:08 II: Finished in 0s
2019-02-05 03:48:08 QQ: 'COPY OFFSET 2 INTO bsa_outpatient_procedures_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Outpatient_Procedures_PUF_1.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:48:15 II: Finished in 7.58s
2019-02-05 03:48:15 QQ: 'SELECT COUNT(*) FROM bsa_outpatient_procedures_2008'
2019-02-05 03:48:15 II: Finished in 0.01s
2019-02-05 03:48:15 QQ: 'COMMIT'
2019-02-05 03:51:50 II: Finished in 3.58s
2019-02-05 03:51:50 bsapuf catalog entry 22 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:51:50 
2019-02-05 03:53:29 'https://downloads.cms.gov/BSAPUF/2008_BSA_Outpatient_Procedures_PUF_2.zip'
2019-02-05 03:53:29 cached in
2019-02-05 03:53:29 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/7f246a123f2e5a6ec8bedc9898e1841c.Rcache'
2019-02-05 03:53:29 copying to
2019-02-05 03:53:29 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:53:29 
2019-02-05 03:53:38 QQ: 'START TRANSACTION'
2019-02-05 03:53:38 II: Finished in 0s
2019-02-05 03:53:38 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:53:38 II: Finished in 0s
2019-02-05 03:53:38 QQ: 'COPY OFFSET 2 INTO bsa_outpatient_procedures_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Outpatient_Procedures_PUF_2.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:53:46 II: Finished in 8.02s
2019-02-05 03:53:46 QQ: 'SELECT COUNT(*) FROM bsa_outpatient_procedures_2008'
2019-02-05 03:53:48 II: Finished in 1.45s
2019-02-05 03:53:48 QQ: 'COMMIT'
2019-02-05 03:54:05 II: Finished in 17.5s
2019-02-05 03:54:08 bsapuf catalog entry 23 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:54:08 
2019-02-05 03:57:29 'https://downloads.cms.gov/BSAPUF/2008_BSA_Outpatient_Procedures_PUF_3.zip'
2019-02-05 03:57:29 cached in
2019-02-05 03:57:29 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/4e6891cdd8680ea42206c2dad0a6c29c.Rcache'
2019-02-05 03:57:29 copying to
2019-02-05 03:57:29 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 03:57:29 
2019-02-05 03:57:35 QQ: 'START TRANSACTION'
2019-02-05 03:57:35 II: Finished in 0s
2019-02-05 03:57:35 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 03:57:35 II: Finished in 0s
2019-02-05 03:57:35 QQ: 'COPY OFFSET 2 INTO bsa_outpatient_procedures_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_Outpatient_Procedures_PUF_3.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 03:57:43 II: Finished in 7.81s
2019-02-05 03:57:43 QQ: 'SELECT COUNT(*) FROM bsa_outpatient_procedures_2008'
2019-02-05 03:57:45 II: Finished in 1.74s
2019-02-05 03:57:45 QQ: 'COMMIT'
2019-02-05 03:58:43 II: Finished in 58.21s
2019-02-05 03:58:43 QQ: 'SELECT COUNT(*) FROM bsa_outpatient_procedures_2008'
2019-02-05 03:58:43 II: Finished in 0s
2019-02-05 03:58:48 bsapuf catalog entry 24 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 03:58:48 
2019-02-05 04:02:43 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_BSA_SNF_Beneficiary_PUF.zip'
2019-02-05 04:02:43 cached in
2019-02-05 04:02:43 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/4b992eafd8a6c8f8f1320741c9abe462.Rcache'
2019-02-05 04:02:43 copying to
2019-02-05 04:02:43 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 04:02:43 
2019-02-05 04:02:43 QQ: 'START TRANSACTION'
2019-02-05 04:02:43 II: Finished in 0s
2019-02-05 04:02:43 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:02:50 II: Finished in 6.59s
2019-02-05 04:02:50 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:02:50 II: Finished in 0.01s
2019-02-05 04:02:50 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:02:50 II: Finished in 0s
2019-02-05 04:02:50 QQ: 'CREATE TABLE bsa_snf_beneficiary_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, snf_adm_cd INTEGER, snf_rhb_cd INTEGER, snf_rhbxs_cd INTEGER, snf_pmt_amt INTEGER, bene_cnt INTEGER)'
2019-02-05 04:02:50 II: Finished in 0s
2019-02-05 04:02:50 QQ: 'COPY OFFSET 2 INTO bsa_snf_beneficiary_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_BSA_SNF_Beneficiary_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 04:02:51 II: Finished in 1.42s
2019-02-05 04:02:51 QQ: 'SELECT COUNT(*) FROM bsa_snf_beneficiary_2010'
2019-02-05 04:02:51 II: Finished in 0s
2019-02-05 04:02:51 QQ: 'COMMIT'
2019-02-05 04:02:52 II: Finished in 1.25s
2019-02-05 04:02:52 QQ: 'SELECT COUNT(*) FROM bsa_snf_beneficiary_2010'
2019-02-05 04:02:52 II: Finished in 0s
2019-02-05 04:02:53 bsapuf catalog entry 25 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 04:02:53 
2019-02-05 04:07:20 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2008_BSA_SNF_Beneficiary_PUF.zip'
2019-02-05 04:07:20 cached in
2019-02-05 04:07:20 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/031f92fd4a942765b3f42a109c7a1856.Rcache'
2019-02-05 04:07:20 copying to
2019-02-05 04:07:20 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 04:07:20 
2019-02-05 04:07:20 QQ: 'START TRANSACTION'
2019-02-05 04:07:20 II: Finished in 0s
2019-02-05 04:07:20 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:07:34 II: Finished in 13.63s
2019-02-05 04:07:34 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:07:34 II: Finished in 0.01s
2019-02-05 04:07:34 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:07:34 II: Finished in 0.01s
2019-02-05 04:07:34 QQ: 'CREATE TABLE bsa_snf_beneficiary_2008 (snf_bene_id STRING, bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, snf_adm_cd INTEGER, snf_rhb_cd INTEGER, snf_rhbxs_cd INTEGER, snf_pmt_amt INTEGER)'
2019-02-05 04:07:34 II: Finished in 0s
2019-02-05 04:07:34 QQ: 'COPY OFFSET 2 INTO bsa_snf_beneficiary_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_BSA_SNF_Beneficiary_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 04:07:34 II: Finished in 0.1s
2019-02-05 04:07:34 QQ: 'SELECT COUNT(*) FROM bsa_snf_beneficiary_2008'
2019-02-05 04:07:34 II: Finished in 0s
2019-02-05 04:07:34 QQ: 'COMMIT'
2019-02-05 04:07:34 II: Finished in 0.59s
2019-02-05 04:07:34 QQ: 'SELECT COUNT(*) FROM bsa_snf_beneficiary_2008'
2019-02-05 04:07:34 II: Finished in 0s
2019-02-05 04:07:35 bsapuf catalog entry 26 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 04:07:35 
2019-02-05 04:17:57 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_ChronicConditions_PUF.zip'
2019-02-05 04:17:57 cached in
2019-02-05 04:17:57 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/d97af55fc4758d71bceb6d43fc5afb9a.Rcache'
2019-02-05 04:17:57 copying to
2019-02-05 04:17:57 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 04:17:57 
2019-02-05 04:18:07 QQ: 'START TRANSACTION'
2019-02-05 04:18:07 II: Finished in 0s
2019-02-05 04:18:07 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:19:47 II: Finished in 1.67s
2019-02-05 04:19:47 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:19:47 II: Finished in 0s
2019-02-05 04:19:47 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:19:47 II: Finished in 0s
2019-02-05 04:19:47 QQ: 'CREATE TABLE chronicconditions_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, cc_alzhdmta INTEGER, cc_cancer INTEGER, cc_chf INTEGER, cc_chrnkidn INTEGER, cc_copd INTEGER, cc_depressn INTEGER, cc_diabetes INTEGER, cc_ischmcht INTEGER, cc_osteoprs INTEGER, cc_ra_oa INTEGER, cc_strketia INTEGER, cc_2_or_more INTEGER, dual_stus INTEGER, bene_count_pa_lt_12 INTEGER, ave_mo_en_pa_lt_12 DOUBLE PRECISION, ave_pa_pay_pa_lt_12 INTEGER, ave_ip_pay_pa_lt_12 INTEGER, ave_snf_pay_pa_lt_12 INTEGER, ave_oth_pay_pa_lt_12 INTEGER, ave_ip_adm_pa_lt_12 DOUBLE PRECISION, ave_snf_days_pa_lt_12 DOUBLE PRECISION, bene_count_pa_eq_12 INTEGER, ave_pa_pay_pa_eq_12 INTEGER, ave_ip_pay_pa_eq_12 INTEGER, ave_snf_pay_pa_eq_12 INTEGER, ave_oth_pay_pa_eq_12 INTEGER, ave_ip_adm_pa_eq_12 DOUBLE PRECISION, ave_snf_days_pa_eq_12 DOUBLE PRECISION, bene_count_pb_lt_12 INTEGER, ave_mo_en_pb_lt_12 DOUBLE PRECISION, ave_pb_pay_pb_lt_12 INTEGER, ave_ca_pay_pb_lt_12 INTEGER, ave_op_pay_pb_lt_12 INTEGER, ave_oth_pay_pb_lt_12 INTEGER, ave_ca_vst_pb_lt_12 DOUBLE PRECISION, ave_op_vst_pb_lt_12 DOUBLE PRECISION, bene_count_pb_eq_12 INTEGER, ave_pb_pay_pb_eq_12 INTEGER, ave_ca_pay_pb_eq_12 INTEGER, ave_op_pay_pb_eq_12 INTEGER, ave_oth_pay_pb_eq_12 INTEGER, ave_ca_vst_pb_eq_12 DOUBLE PRECISION, ave_op_vst_pb_eq_12 DOUBLE PRECISION, bene_count_pc_lt_12 INTEGER, ave_mo_en_pc_lt_12 DOUBLE PRECISION, bene_count_pc_eq_12 INTEGER, bene_count_pd_lt_12 INTEGER, ave_mo_en_pd_lt_12 DOUBLE PRECISION, ave_pde_cst_pd_lt_12 INTEGER, ave_pde_pd_lt_12 DOUBLE PRECISION, bene_count_pd_eq_12 INTEGER, ave_pde_cst_pd_eq_12 INTEGER, ave_pde_pd_eq_12 DOUBLE PRECISION)'
2019-02-05 04:19:47 II: Finished in 0s
2019-02-05 04:19:47 QQ: 'COPY OFFSET 2 INTO chronicconditions_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_Chronic_Conditions_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 04:19:48 II: Finished in 0.18s
2019-02-05 04:19:48 QQ: 'SELECT COUNT(*) FROM chronicconditions_2010'
2019-02-05 04:19:48 II: Finished in 0s
2019-02-05 04:19:48 QQ: 'COMMIT'
2019-02-05 04:19:56 II: Finished in 8.43s
2019-02-05 04:19:56 QQ: 'SELECT COUNT(*) FROM chronicconditions_2010'
2019-02-05 04:19:56 II: Finished in 0s
2019-02-05 04:19:56 bsapuf catalog entry 27 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 04:19:56 
2019-02-05 04:22:00 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2008_Chronic_Conditions_PUF.zip'
2019-02-05 04:22:00 cached in
2019-02-05 04:22:00 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/2bae010ce06a6b092a715ed1f67e0a9c.Rcache'
2019-02-05 04:22:00 copying to
2019-02-05 04:22:00 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 04:22:00 
2019-02-05 04:22:01 QQ: 'START TRANSACTION'
2019-02-05 04:22:01 II: Finished in 0s
2019-02-05 04:22:01 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:22:01 II: Finished in 0s
2019-02-05 04:22:01 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:22:01 II: Finished in 0s
2019-02-05 04:22:01 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:22:01 II: Finished in 0.01s
2019-02-05 04:22:01 QQ: 'CREATE TABLE chronic_conditions_2008 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, cc_alzhdmta INTEGER, cc_cancer INTEGER, cc_chf INTEGER, cc_chrnkidn INTEGER, cc_copd INTEGER, cc_depressn INTEGER, cc_diabetes INTEGER, cc_ischmcht INTEGER, cc_osteoprs INTEGER, cc_ra_oa INTEGER, cc_strketia INTEGER, cc_2_or_more INTEGER, dual_stus INTEGER, bene_count_pa_lt_12 INTEGER, ave_mo_en_pa_lt_12 DOUBLE PRECISION, ave_pa_pay_pa_lt_12 INTEGER, ave_ip_pay_pa_lt_12 INTEGER, ave_snf_pay_pa_lt_12 INTEGER, ave_oth_pay_pa_lt_12 INTEGER, ave_ip_adm_pa_lt_12 DOUBLE PRECISION, ave_snf_days_pa_lt_12 DOUBLE PRECISION, bene_count_pa_eq_12 INTEGER, ave_pa_pay_pa_eq_12 INTEGER, ave_ip_pay_pa_eq_12 INTEGER, ave_snf_pay_pa_eq_12 INTEGER, ave_oth_pay_pa_eq_12 INTEGER, ave_ip_adm_pa_eq_12 DOUBLE PRECISION, ave_snf_days_pa_eq_12 DOUBLE PRECISION, bene_count_pb_lt_12 INTEGER, ave_mo_en_pb_lt_12 DOUBLE PRECISION, ave_pb_pay_pb_lt_12 INTEGER, ave_ca_pay_pb_lt_12 INTEGER, ave_op_pay_pb_lt_12 INTEGER, ave_oth_pay_pb_lt_12 INTEGER, ave_ca_vst_pb_lt_12 DOUBLE PRECISION, ave_op_vst_pb_lt_12 DOUBLE PRECISION, bene_count_pb_eq_12 INTEGER, ave_pb_pay_pb_eq_12 INTEGER, ave_ca_pay_pb_eq_12 INTEGER, ave_op_pay_pb_eq_12 INTEGER, ave_oth_pay_pb_eq_12 INTEGER, ave_ca_vst_pb_eq_12 DOUBLE PRECISION, ave_op_vst_pb_eq_12 DOUBLE PRECISION, bene_count_pc_lt_12 INTEGER, ave_mo_en_pc_lt_12 DOUBLE PRECISION, bene_count_pc_eq_12 INTEGER, bene_count_pd_lt_12 INTEGER, ave_mo_en_pd_lt_12 DOUBLE PRECISION, ave_pde_cst_pd_lt_12 INTEGER, ave_pde_pd_lt_12 DOUBLE PRECISION, bene_count_pd_eq_12 INTEGER, ave_pde_cst_pd_eq_12 INTEGER, ave_pde_pd_eq_12 DOUBLE PRECISION)'
2019-02-05 04:22:01 II: Finished in 0s
2019-02-05 04:22:01 QQ: 'COPY OFFSET 2 INTO chronic_conditions_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_Chronic_Conditions_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 04:22:01 II: Finished in 0.17s
2019-02-05 04:22:01 QQ: 'SELECT COUNT(*) FROM chronic_conditions_2008'
2019-02-05 04:22:01 II: Finished in 0s
2019-02-05 04:22:01 QQ: 'COMMIT'
2019-02-05 04:22:01 II: Finished in 0.52s
2019-02-05 04:22:01 QQ: 'SELECT COUNT(*) FROM chronic_conditions_2008'
2019-02-05 04:22:01 II: Finished in 0.01s
2019-02-05 04:22:02 bsapuf catalog entry 28 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 04:22:02 
2019-02-05 04:34:19 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_IPBS_PUF.zip'
2019-02-05 04:34:19 cached in
2019-02-05 04:34:19 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/ffbd47b3e747b480feae497e82392837.Rcache'
2019-02-05 04:34:19 copying to
2019-02-05 04:34:19 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 04:34:19 
2019-02-05 04:34:21 QQ: 'START TRANSACTION'
2019-02-05 04:34:21 II: Finished in 0s
2019-02-05 04:34:21 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:34:22 II: Finished in 0.66s
2019-02-05 04:34:22 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:34:22 II: Finished in 0s
2019-02-05 04:34:22 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:34:22 II: Finished in 0s
2019-02-05 04:34:22 QQ: 'CREATE TABLE ipbs_2010 (provider_id STRING, hrr_prov STRING, facility_type STRING, bene_cnt INTEGER, death_bene_cnt INTEGER, sex_male_bene_cnt INTEGER, sex_female_bene_cnt INTEGER, race_white_bene_cnt INTEGER, race_black_bene_cnt INTEGER, race_hispn_bene_cnt INTEGER, race_api_bene_cnt INTEGER, race_natind_bene_cnt INTEGER, race_other_bene_cnt INTEGER, age_less_65_bene_cnt INTEGER, age_65_69_bene_cnt INTEGER, age_70_74_bene_cnt INTEGER, age_75_79_bene_cnt INTEGER, age_80_84_bene_cnt INTEGER, age_over_84_bene_cnt INTEGER, dual_bene_cnt INTEGER, non_dual_bene_cnt INTEGER, hrr_diff_bene_cnt INTEGER, afib_bene_cnt INTEGER, alzrdsd_bene_cnt INTEGER, alz_bene_cnt INTEGER, ami_bene_cnt INTEGER, anemia_bene_cnt INTEGER, asthma_bene_cnt INTEGER, brc_bene_cnt INTEGER, cat_bene_cnt INTEGER, chf_bene_cnt INTEGER, ckd_bene_cnt INTEGER, copd_bene_cnt INTEGER, crc_bene_cnt INTEGER, depr_bene_cnt INTEGER, diab_bene_cnt INTEGER, endc_bene_cnt INTEGER, glcm_bene_cnt INTEGER, hfrac_bene_cnt INTEGER, hyperl_bene_cnt INTEGER, hyperp_bene_cnt INTEGER, hypert_bene_cnt INTEGER, hypoth_bene_cnt INTEGER, ihd_bene_cnt INTEGER, lngc_bene_cnt INTEGER, ost_bene_cnt INTEGER, prc_bene_cnt INTEGER, raoa_bene_cnt INTEGER, strk_bene_cnt INTEGER, hrr_bene_desc1 STRING, hrr_bene_desc2 STRING, hrr_bene_desc3 STRING, hrr_bene_desc4 STRING, hrr_bene_desc5 STRING, hrr_bene_cnt1 INTEGER, hrr_bene_cnt2 INTEGER, hrr_bene_cnt3 INTEGER, hrr_bene_cnt4 INTEGER, hrr_bene_cnt5 INTEGER, tapq01_bene_cnt INTEGER, tapq01 INTEGER, tapq03_bene_cnt INTEGER, tapq03 INTEGER, tapq05_bene_cnt INTEGER, tapq05 INTEGER, tapq07_bene_cnt INTEGER, tapq07 INTEGER, tapq08_bene_cnt INTEGER, tapq08 INTEGER, tapq10_bene_cnt INTEGER, tapq10 INTEGER, tapq11_bene_cnt INTEGER, tapq11 INTEGER, tapq12_bene_cnt INTEGER, tapq12 INTEGER, tapq13_bene_cnt INTEGER, tapq13 INTEGER, tapq14_bene_cnt INTEGER, tapq14 INTEGER, tapq15_bene_cnt INTEGER, tapq15 INTEGER, tapq16_bene_cnt INTEGER, tapq16 INTEGER, oer_bene_cnt INTEGER, oer INTEGER, ier_bene_cnt INTEGER, ier INTEGER, covered_days_bene_cnt INTEGER, covered_days INTEGER, covered_stays_bene_cnt INTEGER, covered_stays INTEGER, visits_bene_cnt INTEGER, visits INTEGER, episodes_bene_cnt INTEGER, episodes INTEGER, admits_bene_cnt INTEGER, admits INTEGER, readmits_bene_cnt INTEGER, readmits INTEGER, readmits_diff_prov_bene_cnt INTEGER, readmits_diff_prov INTEGER, actual_pmt INTEGER, standard_pmt INTEGER, outlier_apprvd_pmt INTEGER, readmit_pmt INTEGER, coinsurance INTEGER, deductible INTEGER, pass_thru_costs INTEGER, avg_score DOUBLE PRECISION, avg_lti_months_bene_cnt INTEGER, avg_lti_months DOUBLE PRECISION)'
2019-02-05 04:34:22 II: Finished in 0s
2019-02-05 04:34:22 QQ: 'COPY OFFSET 2 INTO ipbs_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010 IPBS PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 04:34:23 II: Finished in 0.72s
2019-02-05 04:34:23 QQ: 'SELECT COUNT(*) FROM ipbs_2010'
2019-02-05 04:34:23 II: Finished in 0s
2019-02-05 04:34:23 QQ: 'COMMIT'
2019-02-05 04:34:30 II: Finished in 7.14s
2019-02-05 04:34:30 QQ: 'SELECT COUNT(*) FROM ipbs_2010'
2019-02-05 04:34:30 II: Finished in 0s
2019-02-05 04:34:30 bsapuf catalog entry 29 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 04:34:30 
2019-02-05 04:39:21 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2008_IPBS_PUF.zip'
2019-02-05 04:39:21 cached in
2019-02-05 04:39:21 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/523acae5bcdc254b22738ca0c75a4008.Rcache'
2019-02-05 04:39:21 copying to
2019-02-05 04:39:21 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 04:39:21 
2019-02-05 04:39:24 QQ: 'START TRANSACTION'
2019-02-05 04:39:24 II: Finished in 0s
2019-02-05 04:39:24 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:39:26 II: Finished in 2.77s
2019-02-05 04:39:26 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:39:26 II: Finished in 0s
2019-02-05 04:39:26 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:39:26 II: Finished in 0s
2019-02-05 04:39:26 QQ: 'CREATE TABLE ipbs_2008 (provider_id STRING, hrr_prov STRING, facility_type STRING, bene_cnt INTEGER, death_bene_cnt INTEGER, sex_male_bene_cnt INTEGER, sex_female_bene_cnt INTEGER, race_white_bene_cnt INTEGER, race_black_bene_cnt INTEGER, race_hispn_bene_cnt INTEGER, race_api_bene_cnt INTEGER, race_natind_bene_cnt INTEGER, race_other_bene_cnt INTEGER, age_less_65_bene_cnt INTEGER, age_65_69_bene_cnt INTEGER, age_70_74_bene_cnt INTEGER, age_75_79_bene_cnt INTEGER, age_80_84_bene_cnt INTEGER, age_over_84_bene_cnt INTEGER, dual_bene_cnt INTEGER, non_dual_bene_cnt INTEGER, hrr_diff_bene_cnt INTEGER, afib_bene_cnt INTEGER, alzrdsd_bene_cnt INTEGER, alz_bene_cnt INTEGER, ami_bene_cnt INTEGER, anemia_bene_cnt INTEGER, asthma_bene_cnt INTEGER, brc_bene_cnt INTEGER, cat_bene_cnt INTEGER, chf_bene_cnt INTEGER, ckd_bene_cnt INTEGER, copd_bene_cnt INTEGER, crc_bene_cnt INTEGER, depr_bene_cnt INTEGER, diab_bene_cnt INTEGER, endc_bene_cnt INTEGER, glcm_bene_cnt INTEGER, hfrac_bene_cnt INTEGER, hyperl_bene_cnt INTEGER, hyperp_bene_cnt INTEGER, hypert_bene_cnt INTEGER, hypoth_bene_cnt INTEGER, ihd_bene_cnt INTEGER, lngc_bene_cnt INTEGER, ost_bene_cnt INTEGER, prc_bene_cnt INTEGER, raoa_bene_cnt INTEGER, strk_bene_cnt INTEGER, hrr_bene_desc1 STRING, hrr_bene_desc2 STRING, hrr_bene_desc3 STRING, hrr_bene_desc4 STRING, hrr_bene_desc5 STRING, hrr_bene_cnt1 INTEGER, hrr_bene_cnt2 INTEGER, hrr_bene_cnt3 INTEGER, hrr_bene_cnt4 INTEGER, hrr_bene_cnt5 INTEGER, tapq01_bene_cnt INTEGER, tapq01 INTEGER, tapq03_bene_cnt INTEGER, tapq03 INTEGER, tapq05_bene_cnt INTEGER, tapq05 INTEGER, tapq07_bene_cnt INTEGER, tapq07 INTEGER, tapq08_bene_cnt INTEGER, tapq08 INTEGER, tapq10_bene_cnt INTEGER, tapq10 INTEGER, tapq11_bene_cnt INTEGER, tapq11 INTEGER, tapq12_bene_cnt INTEGER, tapq12 INTEGER, tapq13_bene_cnt INTEGER, tapq13 INTEGER, tapq14_bene_cnt INTEGER, tapq14 INTEGER, tapq15_bene_cnt BOOLEAN, tapq15 BOOLEAN, tapq16_bene_cnt INTEGER, tapq16 INTEGER, oer_bene_cnt INTEGER, oer INTEGER, ier_bene_cnt INTEGER, ier INTEGER, covered_days_bene_cnt INTEGER, covered_days INTEGER, covered_stays_bene_cnt INTEGER, covered_stays INTEGER, visits_bene_cnt INTEGER, visits INTEGER, episodes_bene_cnt INTEGER, episodes INTEGER, admits_bene_cnt INTEGER, admits INTEGER, readmits_bene_cnt INTEGER, readmits INTEGER, readmits_diff_prov_bene_cnt INTEGER, readmits_diff_prov INTEGER, actual_pmt INTEGER, standard_pmt INTEGER, outlier_apprvd_pmt INTEGER, readmit_pmt INTEGER, coinsurance INTEGER, deductible INTEGER, pass_thru_costs INTEGER, avg_score DOUBLE PRECISION, avg_lti_months_bene_cnt INTEGER, avg_lti_months DOUBLE PRECISION)'
2019-02-05 04:39:26 II: Finished in 0s
2019-02-05 04:39:26 QQ: 'COPY OFFSET 2 INTO ipbs_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008 IPBS PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 04:39:27 II: Finished in 0.36s
2019-02-05 04:39:27 QQ: 'SELECT COUNT(*) FROM ipbs_2008'
2019-02-05 04:39:27 II: Finished in 0s
2019-02-05 04:39:27 QQ: 'COMMIT'
2019-02-05 04:39:29 II: Finished in 2.38s
2019-02-05 04:39:29 QQ: 'SELECT COUNT(*) FROM ipbs_2008'
2019-02-05 04:39:29 II: Finished in 0s
2019-02-05 04:39:29 bsapuf catalog entry 30 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 04:39:29 
2019-02-05 04:58:01 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2010_PD_Profiles_PUF.zip'
2019-02-05 04:58:01 cached in
2019-02-05 04:58:01 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/2f80811d924cc5b8981c62662f218ddc.Rcache'
2019-02-05 04:58:01 copying to
2019-02-05 04:58:01 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 04:58:01 
2019-02-05 04:58:10 QQ: 'START TRANSACTION'
2019-02-05 04:58:10 II: Finished in 0s
2019-02-05 04:58:10 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:58:26 II: Finished in 16.68s
2019-02-05 04:58:26 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:58:26 II: Finished in 0s
2019-02-05 04:58:26 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 04:58:26 II: Finished in 0s
2019-02-05 04:58:26 QQ: 'CREATE TABLE pd_profiles_2010 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, rxnorm_rxcui INTEGER, drug_major_class STRING, drug_class STRING, pde_drug_type_cd STRING, plan_type STRING, coverage_type STRING, benefit_phase STRING, drug_benefit_type STRING, prescriber_type STRING, gap_coverage STRING, tier_id STRING, mean_rxhcc_score DOUBLE PRECISION, ave_days_supply DOUBLE PRECISION, ave_tot_drug_cost DOUBLE PRECISION, ave_ptnt_pay_amt DOUBLE PRECISION, pde_cnt INTEGER, bene_cnt_cat INTEGER)'
2019-02-05 04:58:26 II: Finished in 0s
2019-02-05 04:58:26 QQ: 'COPY OFFSET 2 INTO pd_profiles_2010 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2010_PD_Profiles_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 04:58:32 II: Finished in 5.27s
2019-02-05 04:58:32 QQ: 'SELECT COUNT(*) FROM pd_profiles_2010'
2019-02-05 04:58:32 II: Finished in 0s
2019-02-05 04:58:32 QQ: 'COMMIT'
2019-02-05 05:05:34 II: Finished in 7.04s
2019-02-05 05:05:34 QQ: 'SELECT COUNT(*) FROM pd_profiles_2010'
2019-02-05 05:05:34 II: Finished in 0.03s
2019-02-05 05:05:34 bsapuf catalog entry 31 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 05:05:34 
2019-02-05 05:46:59 'https://www.cms.gov/Research-Statistics-Data-and-Systems/Downloadable-Public-Use-Files/BSAPUFS/Downloads/2008_PD_Profiles_PUF.zip'
2019-02-05 05:46:59 cached in
2019-02-05 05:46:59 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/d5658ac3f89cfb5161ed9a8582f89093.Rcache'
2019-02-05 05:46:59 copying to
2019-02-05 05:46:59 '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/file47667cd26055'
2019-02-05 05:46:59 
2019-02-05 05:47:14 QQ: 'START TRANSACTION'
2019-02-05 05:47:14 II: Finished in 0s
2019-02-05 05:47:14 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 05:47:43 II: Finished in 28.68s
2019-02-05 05:47:46 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 05:47:46 II: Finished in 0s
2019-02-05 05:47:46 QQ: 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=schemas.id'
2019-02-05 05:47:46 II: Finished in 0s
2019-02-05 05:47:46 QQ: 'CREATE TABLE pd_profiles_2008 (bene_sex_ident_cd INTEGER, bene_age_cat_cd INTEGER, rxnorm_rxcui INTEGER, drug_major_class STRING, drug_class STRING, pde_drug_type_cd STRING, plan_type STRING, coverage_type STRING, benefit_phase STRING, drug_benefit_type STRING, prescriber_type STRING, gap_coverage STRING, tier_id STRING, mean_rxhcc_score DOUBLE PRECISION, ave_days_supply DOUBLE PRECISION, ave_tot_drug_cost DOUBLE PRECISION, ave_ptnt_pay_amt DOUBLE PRECISION, pde_cnt INTEGER, bene_cnt_cat INTEGER)'
2019-02-05 05:47:46 II: Finished in 0s
2019-02-05 05:47:46 QQ: 'COPY OFFSET 2 INTO pd_profiles_2008 FROM '/export/scratch1/home/hannes/eanthony/r-tmp/bsapuf/RtmpMfkaFR/unzips/2008_PD_Profiles_PUF.csv' USING DELIMITERS ',','\n','"' NULL as ''  '
2019-02-05 05:48:14 II: Finished in 31.73s
2019-02-05 05:48:14 QQ: 'SELECT COUNT(*) FROM pd_profiles_2008'
2019-02-05 05:48:14 II: Finished in 0s
2019-02-05 05:48:14 QQ: 'COMMIT'
2019-02-05 05:54:35 II: Finished in 6.34s
2019-02-05 05:54:35 QQ: 'SELECT COUNT(*) FROM pd_profiles_2008'
2019-02-05 05:54:35 II: Finished in 0.04s
2019-02-05 05:54:36 bsapuf catalog entry 32 of 32 stored in '/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937/MonetDB'
2019-02-05 05:54:36 
2019-02-05 05:54:36 bsapuf local download completed
2019-02-05 05:54:36 
2019-02-05 05:54:36 > 

setup return code=0
2019-02-05 05:54:49 
2019-02-05 05:54:49 R version 3.5.1 (2018-07-02) -- "Feather Spray"
2019-02-05 05:54:49 Copyright (C) 2018 The R Foundation for Statistical Computing
2019-02-05 05:54:49 Platform: x86_64-pc-linux-gnu (64-bit)
2019-02-05 05:54:49 
2019-02-05 05:54:49 R is free software and comes with ABSOLUTELY NO WARRANTY.
2019-02-05 05:54:49 You are welcome to redistribute it under certain conditions.
2019-02-05 05:54:49 Type 'license()' or 'licence()' for distribution details.
2019-02-05 05:54:49 
2019-02-05 05:54:49   Natural language support but running in an English locale
2019-02-05 05:54:49 
2019-02-05 05:54:49 R is a collaborative project with many contributors.
2019-02-05 05:54:49 Type 'contributors()' for more information and
2019-02-05 05:54:49 'citation()' on how to cite R or R packages in publications.
2019-02-05 05:54:49 
2019-02-05 05:54:49 Type 'demo()' for some demos, 'help()' for on-line help, or
2019-02-05 05:54:49 'help.start()' for an HTML browser interface to help.
2019-02-05 05:54:49 Type 'q()' to quit R.
2019-02-05 05:54:49 
2019-02-05 05:54:59 > setwd( Sys.getenv( "RWD" ) )
2019-02-05 05:54:59 > 
2019-02-05 05:54:59 > machine_specific_replacements <- 
2019-02-05 05:54:59 + 	list( 
2019-02-05 05:54:59 + 		
2019-02-05 05:54:59 + 		# replace the folder path on macnix
2019-02-05 05:54:59 + 		c( 'path.expand( \"~\" ) , \"BSAPUF\"' , paste0( '"' , getwd() , '"' ) ) ,
2019-02-05 05:54:59 + 		
2019-02-05 05:54:59 + 		# change other things in the script to be run
2019-02-05 05:54:59 + 		c( "hello" , "howdy" )
2019-02-05 05:54:59 + 		
2019-02-05 05:54:59 + 	)
2019-02-05 05:54:59 > 
2019-02-05 05:54:59 > source( lodown::syntaxtractor( "bsapuf" , replacements = machine_specific_replacements , setup_test = "test" ) , echo = TRUE )
2019-02-05 05:55:01 
2019-02-05 05:55:01 > library(DBI)
2019-02-05 05:55:02 
2019-02-05 05:55:02 > dbdir <- file.path("/export/scratch1/home/hannes/eanthony/r-wd/bsapuf-1549328937", 
2019-02-05 05:55:02 +     "MonetDB")
2019-02-05 05:55:02 
2019-02-05 05:55:02 > db <- dbConnect(MonetDBLite::MonetDBLite(), dbdir)
2019-02-05 06:05:55 
2019-02-05 06:05:55 > dbSendQuery(db, "ALTER TABLE bsa_partd_events_2008 ADD COLUMN brand_name_drug INTEGER")
2019-02-05 06:05:55 QQ: 'ALTER TABLE bsa_partd_events_2008 ADD COLUMN brand_name_drug INTEGER'
2019-02-05 06:07:00 II: Finished in 1.09s
2019-02-05 06:07:00 <MonetDBEmbeddedResult>
2019-02-05 06:07:00   SQL  ALTER TABLE bsa_partd_events_2008 ADD COLUMN brand_name_drug INTEGER
2019-02-05 06:07:00   ROWS Fetched: 0 [complete]
2019-02-05 06:07:00        Changed: 0
2019-02-05 06:07:00 
2019-02-05 06:07:00 > dbSendQuery(db, "UPDATE bsa_partd_events_2008 \n\tSET brand_name_drug = \n\t\tCASE \n\t\t\tWHEN pde_drug_type_cd = 1 THEN 1 \n\t\t\tWHEN pde_drug_ty ..." ... [TRUNCATED] 
2019-02-05 06:07:01 QQ: 'UPDATE bsa_partd_events_2008 
2019-02-05 06:07:01 	SET brand_name_drug = 
2019-02-05 06:07:01 		CASE 
2019-02-05 06:07:01 			WHEN pde_drug_type_cd = 1 THEN 1 
2019-02-05 06:07:01 			WHEN pde_drug_type_cd = 2 THEN 0 
2019-02-05 06:07:01 			ELSE NULL 
2019-02-05 06:07:01 		END'
2019-02-05 06:19:56 II: Finished in 12.93s
2019-02-05 06:19:56 <MonetDBEmbeddedResult>
2019-02-05 06:19:56   SQL  UPDATE bsa_partd_events_2008 
2019-02-05 06:19:56 	SET brand_name_drug = 
2019-02-05 06:19:56 		CASE 
2019-02-05 06:19:56 			WHEN pde_drug_type_cd = 1 THEN 1 
2019-02-05 06:19:56 			WHEN pde_drug_type_cd = 2 THEN 0 
2019-02-05 06:19:56 			ELSE NULL 
2019-02-05 06:19:56 		END
2019-02-05 06:19:56   ROWS Fetched: 0 [complete]
2019-02-05 06:19:56        Changed: 50325988
2019-02-05 06:19:56 
2019-02-05 06:19:56 > dbGetQuery(db, "SELECT COUNT(*) FROM bsa_partd_events_2008")
2019-02-05 06:19:56 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 06:19:58 II: Finished in 1.57s
2019-02-05 06:19:58         L3
2019-02-05 06:19:58 1 50325988
2019-02-05 06:19:58 
2019-02-05 06:19:58 > dbGetQuery(db, "SELECT\n\t\tbene_sex_ident_cd ,\n\t\tCOUNT(*) \n\tFROM bsa_partd_events_2008\n\tGROUP BY bene_sex_ident_cd")
2019-02-05 06:19:58 QQ: 'SELECT
2019-02-05 06:19:58 		bene_sex_ident_cd ,
2019-02-05 06:19:58 		COUNT(*) 
2019-02-05 06:19:58 	FROM bsa_partd_events_2008
2019-02-05 06:19:58 	GROUP BY bene_sex_ident_cd'
2019-02-05 06:20:02 II: Finished in 4.18s
2019-02-05 06:20:02   bene_sex_ident_cd       L3
2019-02-05 06:20:02 1                 1 17754634
2019-02-05 06:20:02 2                 2 32571354
2019-02-05 06:20:02 
2019-02-05 06:20:02 > dbGetQuery(db, "SELECT AVG( pde_drug_cost ) FROM bsa_partd_events_2008")
2019-02-05 06:20:02 QQ: 'SELECT AVG( pde_drug_cost ) FROM bsa_partd_events_2008'
2019-02-05 06:20:05 II: Finished in 2.69s
2019-02-05 06:20:05         L3
2019-02-05 06:20:05 1 63.89651
2019-02-05 06:20:05 
2019-02-05 06:20:05 > dbGetQuery(db, "SELECT \n\t\tbene_sex_ident_cd , \n\t\tAVG( pde_drug_cost ) AS mean_pde_drug_cost\n\tFROM bsa_partd_events_2008 \n\tGROUP BY bene_se ..." ... [TRUNCATED] 
2019-02-05 06:20:05 QQ: 'SELECT 
2019-02-05 06:20:05 		bene_sex_ident_cd , 
2019-02-05 06:20:05 		AVG( pde_drug_cost ) AS mean_pde_drug_cost
2019-02-05 06:20:05 	FROM bsa_partd_events_2008 
2019-02-05 06:20:05 	GROUP BY bene_sex_ident_cd'
2019-02-05 06:20:06 II: Finished in 0.8s
2019-02-05 06:20:06   bene_sex_ident_cd mean_pde_drug_cost
2019-02-05 06:20:06 1                 1           69.89219
2019-02-05 06:20:06 2                 2           60.62827
2019-02-05 06:20:06 
2019-02-05 06:20:06 > dbSendQuery(db, "CREATE FUNCTION \n\t\tdiv_noerror(l DOUBLE, r DOUBLE) \n\tRETURNS DOUBLE \n\tEXTERNAL NAME calc.div_noerror")
2019-02-05 06:20:06 QQ: 'CREATE FUNCTION 
2019-02-05 06:20:06 		div_noerror(l DOUBLE, r DOUBLE) 
2019-02-05 06:20:06 	RETURNS DOUBLE 
2019-02-05 06:20:06 	EXTERNAL NAME calc.div_noerror'
2019-02-05 06:20:17 II: Finished in 10.86s
2019-02-05 06:20:17 <MonetDBEmbeddedResult>
2019-02-05 06:20:17   SQL  CREATE FUNCTION 
2019-02-05 06:20:17 		div_noerror(l DOUBLE, r DOUBLE) 
2019-02-05 06:20:17 	RETURNS DOUBLE 
2019-02-05 06:20:17 	EXTERNAL NAME calc.div_noerror
2019-02-05 06:20:17   ROWS Fetched: 0 [complete]
2019-02-05 06:20:17        Changed: 50325988
2019-02-05 06:20:17 
2019-02-05 06:20:17 > dbGetQuery(db, "SELECT \n\t\tbene_age_cat_cd , \n\t\tdiv_noerror( \n\t\t\tCOUNT(*) , \n\t\t\t( SELECT COUNT(*) FROM bsa_partd_events_2008 ) \n\t\t)  ..." ... [TRUNCATED] 
2019-02-05 06:20:17 QQ: 'SELECT 
2019-02-05 06:20:17 		bene_age_cat_cd , 
2019-02-05 06:20:17 		div_noerror( 
2019-02-05 06:20:17 			COUNT(*) , 
2019-02-05 06:20:17 			( SELECT COUNT(*) FROM bsa_partd_events_2008 ) 
2019-02-05 06:20:17 		) AS share_bene_age_cat_cd
2019-02-05 06:20:17 	FROM bsa_partd_events_2008 
2019-02-05 06:20:17 	GROUP BY bene_age_cat_cd'
2019-02-05 06:20:20 II: Finished in 3.31s
2019-02-05 06:20:20   bene_age_cat_cd share_bene_age_cat_cd
2019-02-05 06:20:20 1               2             0.1649136
2019-02-05 06:20:20 2               4             0.1515217
2019-02-05 06:20:20 3               1             0.2285230
2019-02-05 06:20:20 4               6             0.1301810
2019-02-05 06:20:20 5               3             0.1684461
2019-02-05 06:20:20 6               5             0.1564146
2019-02-05 06:20:20 
2019-02-05 06:20:20 > dbGetQuery(db, "SELECT SUM( pde_drug_cost ) FROM bsa_partd_events_2008")
2019-02-05 06:20:20 QQ: 'SELECT SUM( pde_drug_cost ) FROM bsa_partd_events_2008'
2019-02-05 06:20:20 II: Finished in 0.02s
2019-02-05 06:20:20           L3
2019-02-05 06:20:20 1 3215655170
2019-02-05 06:20:20 
2019-02-05 06:20:20 > dbGetQuery(db, "SELECT \n\t\tbene_sex_ident_cd , \n\t\tSUM( pde_drug_cost ) AS sum_pde_drug_cost \n\tFROM bsa_partd_events_2008 \n\tGROUP BY bene_se ..." ... [TRUNCATED] 
2019-02-05 06:20:20 QQ: 'SELECT 
2019-02-05 06:20:20 		bene_sex_ident_cd , 
2019-02-05 06:20:20 		SUM( pde_drug_cost ) AS sum_pde_drug_cost 
2019-02-05 06:20:20 	FROM bsa_partd_events_2008 
2019-02-05 06:20:20 	GROUP BY bene_sex_ident_cd'
2019-02-05 06:20:21 II: Finished in 0.9s
2019-02-05 06:20:21   bene_sex_ident_cd sum_pde_drug_cost
2019-02-05 06:20:21 1                 1        1240910190
2019-02-05 06:20:21 2                 2        1974744980
2019-02-05 06:20:21 
2019-02-05 06:20:21 > dbGetQuery(db, "SELECT QUANTILE( pde_drug_cost , 0.5 ) FROM bsa_partd_events_2008")
2019-02-05 06:20:21 QQ: 'SELECT QUANTILE( pde_drug_cost , 0.5 ) FROM bsa_partd_events_2008'
2019-02-05 06:20:25 II: Finished in 4.03s
2019-02-05 06:20:25   L3
2019-02-05 06:20:25 1 20
2019-02-05 06:20:25 
2019-02-05 06:20:25 > dbGetQuery(db, "SELECT \n\t\tbene_sex_ident_cd , \n\t\tQUANTILE( pde_drug_cost , 0.5 ) AS median_pde_drug_cost\n\tFROM bsa_partd_events_2008 \n\tGRO ..." ... [TRUNCATED] 
2019-02-05 06:20:25 QQ: 'SELECT 
2019-02-05 06:20:25 		bene_sex_ident_cd , 
2019-02-05 06:20:25 		QUANTILE( pde_drug_cost , 0.5 ) AS median_pde_drug_cost
2019-02-05 06:20:25 	FROM bsa_partd_events_2008 
2019-02-05 06:20:25 	GROUP BY bene_sex_ident_cd'
2019-02-05 06:20:31 II: Finished in 5.97s
2019-02-05 06:20:31   bene_sex_ident_cd median_pde_drug_cost
2019-02-05 06:20:31 1                 1                   20
2019-02-05 06:20:31 2                 2                   20
2019-02-05 06:20:31 
2019-02-05 06:20:31 > dbGetQuery(db, "SELECT\n\t\tAVG( pde_drug_cost )\n\tFROM bsa_partd_events_2008\n\tWHERE pde_drug_pat_pay_cd = 3")
2019-02-05 06:20:31 QQ: 'SELECT
2019-02-05 06:20:31 		AVG( pde_drug_cost )
2019-02-05 06:20:31 	FROM bsa_partd_events_2008
2019-02-05 06:20:31 	WHERE pde_drug_pat_pay_cd = 3'
2019-02-05 06:20:38 II: Finished in 7.17s
2019-02-05 06:20:38         L3
2019-02-05 06:20:38 1 32.80798
2019-02-05 06:20:38 
2019-02-05 06:20:38 > dbGetQuery(db, "SELECT \n\t\tVAR_SAMP( pde_drug_cost ) , \n\t\tSTDDEV_SAMP( pde_drug_cost ) \n\tFROM bsa_partd_events_2008")
2019-02-05 06:20:38 QQ: 'SELECT 
2019-02-05 06:20:38 		VAR_SAMP( pde_drug_cost ) , 
2019-02-05 06:20:38 		STDDEV_SAMP( pde_drug_cost ) 
2019-02-05 06:20:38 	FROM bsa_partd_events_2008'
2019-02-05 06:20:39 II: Finished in 0.85s
2019-02-05 06:20:39        L3      L5
2019-02-05 06:20:39 1 20426.4 142.921
2019-02-05 06:20:39 
2019-02-05 06:20:39 > dbGetQuery(db, "SELECT \n\t\tbene_sex_ident_cd , \n\t\tVAR_SAMP( pde_drug_cost ) AS var_pde_drug_cost ,\n\t\tSTDDEV_SAMP( pde_drug_cost ) AS stddev_ ..." ... [TRUNCATED] 
2019-02-05 06:20:39 QQ: 'SELECT 
2019-02-05 06:20:39 		bene_sex_ident_cd , 
2019-02-05 06:20:39 		VAR_SAMP( pde_drug_cost ) AS var_pde_drug_cost ,
2019-02-05 06:20:39 		STDDEV_SAMP( pde_drug_cost ) AS stddev_pde_drug_cost
2019-02-05 06:20:39 	FROM bsa_partd_events_2008 
2019-02-05 06:20:39 	GROUP BY bene_sex_ident_cd'
2019-02-05 06:20:40 II: Finished in 1.53s
2019-02-05 06:20:40   bene_sex_ident_cd var_pde_drug_cost stddev_pde_drug_cost
2019-02-05 06:20:40 1                 1          24814.49             157.5262
2019-02-05 06:20:40 2                 2          18004.18             134.1797
2019-02-05 06:20:40 
2019-02-05 06:20:40 > dbGetQuery(db, "SELECT \n\t\tCORR( CAST( brand_name_drug AS DOUBLE ) , CAST( pde_drug_cost AS DOUBLE ) )\n\tFROM bsa_partd_events_2008")
2019-02-05 06:20:40 QQ: 'SELECT 
2019-02-05 06:20:40 		CORR( CAST( brand_name_drug AS DOUBLE ) , CAST( pde_drug_cost AS DOUBLE ) )
2019-02-05 06:20:40 	FROM bsa_partd_events_2008'
2019-02-05 06:20:46 II: Finished in 5.99s
2019-02-05 06:20:46          L5
2019-02-05 06:20:46 1 0.4174422
2019-02-05 06:20:46 
2019-02-05 06:20:46 > dbGetQuery(db, "SELECT \n\t\tbene_sex_ident_cd , \n\t\tCORR( CAST( brand_name_drug AS DOUBLE ) , CAST( pde_drug_cost AS DOUBLE ) )\n\tFROM bsa_partd ..." ... [TRUNCATED] 
2019-02-05 06:20:46 QQ: 'SELECT 
2019-02-05 06:20:46 		bene_sex_ident_cd , 
2019-02-05 06:20:46 		CORR( CAST( brand_name_drug AS DOUBLE ) , CAST( pde_drug_cost AS DOUBLE ) )
2019-02-05 06:20:46 	FROM bsa_partd_events_2008 
2019-02-05 06:20:46 	GROUP BY bene_sex_ident_cd'
2019-02-05 06:20:52 II: Finished in 5.84s
2019-02-05 06:20:52   bene_sex_ident_cd        L5
2019-02-05 06:20:52 1                 1 0.4244837
2019-02-05 06:20:52 2                 2 0.4151172
2019-02-05 06:20:52 
2019-02-05 06:20:52 > library(dplyr)
2019-02-05 06:20:52 
2019-02-05 06:20:52 Attaching package: ‘dplyr’
2019-02-05 06:20:52 
2019-02-05 06:20:52 The following objects are masked from ‘package:stats’:
2019-02-05 06:20:52 
2019-02-05 06:20:52     filter, lag
2019-02-05 06:20:52 
2019-02-05 06:20:52 The following objects are masked from ‘package:base’:
2019-02-05 06:20:52 
2019-02-05 06:20:52     intersect, setdiff, setequal, union
2019-02-05 06:20:52 
2019-02-05 06:20:52 
2019-02-05 06:20:52 > dplyr_db <- MonetDBLite::src_monetdblite(dbdir)
2019-02-05 06:27:54 
2019-02-05 06:27:54 > bsapuf_tbl <- tbl(dplyr_db, "bsa_partd_events_2008")
2019-02-05 06:27:54 QQ: 'SELECT *
2019-02-05 06:27:54 FROM "bsa_partd_events_2008" AS "zzz1"
2019-02-05 06:27:54 WHERE (0 = 1)'
2019-02-05 06:27:55 II: Finished in 1.05s
2019-02-05 06:27:55 
2019-02-05 06:27:55 > bsapuf_tbl %>% summarize(mean = mean(pde_drug_cost))
2019-02-05 06:27:55 QQ: 'SELECT AVG("pde_drug_cost") AS "mean"
2019-02-05 06:27:55 FROM "bsa_partd_events_2008"
2019-02-05 06:27:55 LIMIT 10'
2019-02-05 06:27:55 II: Finished in 0.02s
2019-02-05 06:28:02 # Source:   lazy query [?? x 1]
2019-02-05 06:28:02 # Database: MonetDBEmbeddedConnection
2019-02-05 06:28:02    mean
2019-02-05 06:28:02   <dbl>
2019-02-05 06:28:02 1  63.9
2019-02-05 06:28:02 
2019-02-05 06:28:02 > bsapuf_tbl %>% group_by(bene_sex_ident_cd) %>% summarize(mean = mean(pde_drug_cost))
2019-02-05 06:28:02 QQ: 'SELECT "bene_sex_ident_cd", AVG("pde_drug_cost") AS "mean"
2019-02-05 06:28:02 FROM "bsa_partd_events_2008"
2019-02-05 06:28:02 GROUP BY "bene_sex_ident_cd"
2019-02-05 06:28:02 LIMIT 10'
2019-02-05 06:28:11 II: Finished in 9.28s
2019-02-05 06:28:11 # Source:   lazy query [?? x 2]
2019-02-05 06:28:11 # Database: MonetDBEmbeddedConnection
2019-02-05 06:28:11   bene_sex_ident_cd  mean
2019-02-05 06:28:11               <int> <dbl>
2019-02-05 06:28:11 1                 1  69.9
2019-02-05 06:28:11 2                 2  60.6
2019-02-05 06:28:11 
2019-02-05 06:28:11 > dbGetQuery(db, "SELECT COUNT(*) FROM bsa_partd_events_2008")
2019-02-05 06:28:11 QQ: 'SELECT COUNT(*) FROM bsa_partd_events_2008'
2019-02-05 06:28:11 II: Finished in 0s
2019-02-05 06:28:11         L3
2019-02-05 06:28:11 1 50325988
2019-02-05 06:28:11 
2019-02-05 06:28:11 > dbDisconnect(db, shutdown = TRUE)
2019-02-05 06:28:11 Warning messages:
2019-02-05 06:28:11 1: Missing values are always removed in SQL.
2019-02-05 06:28:11 Use `AVG(x, na.rm = TRUE)` to silence this warning 
2019-02-05 06:28:11 2: Missing values are always removed in SQL.
2019-02-05 06:28:11 Use `AVG(x, na.rm = TRUE)` to silence this warning 
2019-02-05 06:28:11 > 

test return code=0