Topics started by Tuan Vo
Why does the problem "Invalid value in column 2 for type Int8" always exist when running ads integrator although the data type is varchar (not integer)?
Hi everyone, wish you have a happy new year.I have had a big problem when working with ADS Integrator and now I still cannot fix that problem. I have been stuck with this for 2 days. The problem is “Invalid value in column 2 for type Int8” with the column that has a varchar type (not integer or numeric data type).More specific, I have a csv file with the name ip_address_string_new with 6 columns, and all columns I have modified it with varchar data type. When I run csv downloader for this csv file, it still runs successfully and nothing happens. But when I run the ADS integrator, the errors folder appear with the ip_address_string_new rejected file and ip_address_string_new exception file. In the ip_address_string_new exception file, it said that “Invalid value in column 2 for type Int8 - '' len 0” like the image belowAnd In the ip_address_string_new rejected file, there’re some records like the image below. It said that in the column 2 in each record, the ADS Integrator cannot conve
Hi guys,I have request for creating metrics with the formatting like HH:MM or MM:SS or HH:MM:SS like the image above. My metric will return a decimal number and then I must format it in the time format. Assume that my metric result is a number of seconds, I think that maybe I will divide the number by 86400.0 (the number of seconds in a day), 3600.0 (the number of minutes in a day) and 60 (the number of hours in a day).This is the first time I’ve formatted metric related to time format, so I don’t have any idea about it. Do you have any better idea?Thanks for your help!
Already have an account? Login
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.