Search This Blog

Facebook Talkie

BLOGGER TITLE

Blogger CONTENT

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to use SUM() in MySQL for calculated values -

in mysql, dont know how use function sum calculated values. could me please? in code below, latest part. thing want add row @ end, summarizing "calculado" column thank in advance select p.id_order ref, concat (di.firstname,' ',di.lastname) nombre, ca.weight peso, if (ca.weight<1,(1), if (ca.weight>=1 , (ca.weight<3),(2), if (ca.weight>=3 , (ca.weight<5),(3), if (ca.weight>=5 , (ca.weight<8),(4), if (ca.weight>=8 , (ca.weight<10),(5), if (ca.weight>=10 , (ca.weight<15),(6), if (ca.weight>=15 , (ca.weight<20),(7), if (ca.weight>=20,(ca.weight*(0.5)),'error' )))))))) calculado, p.invoice_date fecha ps_orders p left join ps_address di on (p.id_address_delivery = di.id_address) left join ps_order_carrier ca on (p.id_order = ca.id_order) date(p.invoice_date) >= concat(date_format(last_day(now...

ios - IBOutlet for image button not correctly referencing button after recreating outlet -

i have custom button image. have iboutlet reference in viewcontroller.swift file. the button working hooked wrong outlet. removed of outlets , actions button , similar buttons , remade them. @ point stopped working. i first tried change image button code: star1backbuttonreference.setimage(uiimage(named: "starfull_48dp.png"), forstate: this didn't anything. after thinking problem code changing image decided check few things. so tried hide button this: star1backbuttonreference.hidden = true this did not either think there problem iboutlet reference star1backbuttonreference , found instance change/hide image , reference. the reference this: @iboutlet var star1backbuttonreference: uibutton! i checked referencing outlet on storyboard , correct (one side viewcontroller other side star1backbuttonreference). there must mistake have done in connecting outlet or deleting old one. if deleting referencing outlet must remove it's reference conn...

Java Huge csv file processing and storing using Apache Spark/ Kafka/ Storm to Cassandra -

i working on requirement need read sensor data csv/tsv , insert cassandra db. csv format: sensor1 timestamp1 value sensor1 timestamp2 value sensor2 timestamp1 value sensor2 timestamp3 value details: user can upload file our web application. once file uploaded, need display unique values column user in next page. for example -> sensor1 node1 sensor2 node2 sensorn create user can either map sensor1 existing primary key called node1, in case timestamps , values sensor1 added table primary key equal node1 or create primary key, in case timestamps , values added new primary key. i able implement using java8 streaming , collection. working small csv file. question: how can upload huge csv/ tsv file (200 gb) web application? shall upload file in hdfs , specify path in ui? have split huge file small chunks (50 mb each). how can unique values first column? can use kafka/ spark here? need insert timestamp/ value cassandra db. again can use kafka/ spark here? ...