agent1.channels = ch1
agent1.sinks = HIVE
agent1.sources = sql-source
#
agent1.sources = sql-source
agent1.sources.sql-source.type = org.keedio.flume.source.SQLSource
agent1.sources.sql-source.channels = ch1
#
#
# URL to connect to database (currently only mysql is supported)
#agent1.sources.sql-source.connection.url = jdbc:oracle:thin:@<IP>:<SID>
agent1.sources.sql-source.hibernate.connection.url = jdbc:oracle:thin:@<IP>:<SID>
#
# # Database connection properties
agent1.sources.sql-source.hibernate.connection.user = xxxxxxx
agent1.sources.sql-source.hibernate.connection.password = xxxxxxx
agent1.sources.sql-source.table = ods_user.bb_rm_data
#agent1.sources.sql-source.database = ods_user
#
agent1.sources.sql-source.columns.to.select = *
agent1.sources.sql-source.max.rows = 100
#   # Increment column properties
#   # agent1.sources.sql-source.incremental.column.name = id
#   # Increment value is from you want to start taking data from tables (0 will import entire table)
# agent1.sources.sql-source.incremental.value = 0
#agent1.sources.sql-source.hibernate.dialect = org.keedio.flume.source.SQLServerCustomDialect
# Query delay, each configured milisecond the query will be sent
agent1.sources.sql-source.run.query.delay=5000000
#
# Status file is used to save last readed row
agent1.sources.sql-source.status.file.path = /home/dev_Rht
agent1.sources.sql-source.status.file.name = sql-source.status
#
#channel properties
agent1.channels.ch1.type = memory
agent1.channels.ch1.capacity = 2000000
#
agent1.sinks.HIVE.type = hive
agent1.sinks.HIVE.channel = ch1
agent1.sinks.HIVE.hive.metastore = thrift://localhost:9083
agent1.sinks.HIVE.hive.database = default
agent1.sinks.HIVE.hive.table = fi_bb6
agent1.sinks.HIVE.useLocalTimeStamp = false
agent1.sinks.HIVE.round = true
agent1.sinks.HIVE.roundValue = 10
agent1.sinks.HIVE.roundUnit = minute
agent1.sinks.HIVE.serializer = DELIMITED
agent1.sinks.HIVE.serializer.delimiter = "," 
agent1.sinks.HIVE.serializer.serdeSeparator = ','
agent1.sinks.HIVE.serializer.fieldnames = col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15,col16,col17,col18,col19,col20,col21,col22,col23,col24,col25,col26,col27,col28,col29,col30