cdrs | Cassandra DB native client written in Rust language

:)

I use postgresql 13 and I was sure I understand how to use PARTITION BY but I guess I was wrong. I created the following example to illustrate my problem.

I created this table:

I have a column named "impact" which has data in nested Json format

input: [{"internalid":"079","impactid":[{"position":"1","typeid":"NOEUD","value":"G1"},{"position":"2","typeid":"ID","value":"001"},{"position":"3","typeid":"CODE_CI","value":"14"}],"typeid":"BTS","cdrs":"X110","belong":"OF","impactclass":"R","count":"0","numberaccessimpacted":"0","impactcalculationrequest":null},{"internalid":"6381075","impactid":[{"position":"1","typeid":"NOEUD","value":"G3"},{"position":"2","typeid":"ID","value":"003"},{"position":"3","typeid":"CI","value":"58"}],"typeid":"BTS","cdrs":"X110","belong":"OF","impactclass":"R","count":"0","numberaccessimpacted":"0","impactcalculationrequest":null},{"internalid":"6381071","impactid":[{"position":"1","typeid":"NOEUD","value":"G2"},{"position":"2","typeid":"IDT","value":"002"},{"position":"3","typeid":"CI","value":"57"}],"typeid":"BTS","cdrs":"X110","belong":"OF","impactclass":"R","count":"0","numberaccessimpacted":"0","impactcalculationrequest":null}]

I use the code below:

I have the next csv and I need get the values duplicated from DialedNumer column and then the averege Duration of those duplicates.

I already got the duplicates with the next code:

I've been able to setup Asterisk to log CDRs to a MySQL database using the ODBC option. The challenge I am currently facing is that only calls with the disposition ANSWERED are logged. NO ANSWER, BUSY and other calls are not logged in the database though I see the status from the logs.

I place the calls using ARI which connects to a stasis app when the call is answered.

How do I ensure asterisk logs all calls to the database, irrespective of the call status.

I am using Asterisk 16.2.1 and added a additional field to the cdr table.

I have a cursor to update country_id column of one table.

Here is the my code .

I have an existing PostgreSQL Database and I want to create the Model for a table manually because scaffolding does not work. Why does running db.CDRs.First(); throw an exception?

Program.cs:

:)

I have Zabbix 4.4.1 installed on Ubuntu 19.10.

I have a postgresql plugin configured and working properly so it checks my database metrics.

I have a a table that I want to check a timestamp column for the last inserted row. column name is insert_time.

if the last inserted row have a insert time of more then 5 minutes to product warning and 10 minutes to product error.

I'm new to zabbix.. all I did so far is for googling, not sure if that's the way to go.. it's probably not cause it's not working :)

ok so first thing I did is created a bash files at /etc/zabbix/mytools, get-last-insert-time.sh.

I perform the query and send the output to zabbix_sender with the following template:

I have a hive table which contains call data records(CDRs). I have the table partitioned on the phone number and bucketed on call_date. Now when I am inserting data into hive the back dated call_date are creating small files in my buckets which is creating name node metadata increase and performance slowdown. Is there a way to merge these small files into one.

I'm trying to obtain the results in yyyy-mm-dd format from unixtimestamp column but getting in yyyy-mm-dd hh:mm:ss

My data in receive_time column is following: