back soft

امروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...

امروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...

امروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...

امروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...

امروزدخترم رابردم دندانپزشکی .یکی ازهمکاران قدیمی به اسم خانم شریفی رادیدم خوشحال شدم ،راستش برای من فرقی نمی کنه که خاطره خوب ازهمکارام داشته باشم یانه وقتی بعدازمدتهااونهارامی بینم خوشحال میشم،بعدرف...

Vote count: 0 Good Afteoon, I have been trying to solve this problem for days now. None of the suggestions on stack overflow have been helpful. When trying to upload my app, I get the error: "You must supply a CFBundleIdentifier for this request". The identifiers (UTI format) in info.plist, "General Identity", iTunesCoect and App ID (Apple Developer) are all similar. When getting the CFBundleIdentifier in applicationdidFinishLaunchingWithOptions: I get the same result. I have changed the project name, maybe it has something to do with that? Any suggestions? Thanks! screenshot Error Message asked 27 secs agoJeeGee Let's block ads! بخوانید...

Vote count: 0 I`m trying to calculate CR(Conversion Rate) of column name 'action_type'. The column 'action_type' is allocated to string values as follows... 1 : sale 2 : click So, I think the conversion rate is '(SUM(sale) / SUM(click)) * 100". The values '1'(sale) and '2'(click) are in the same column 'action_type'. How do I write a sql query in hive? Thank you! edited 26 secs agothreadp asked 2 mins agominsu Let's block ads! بخوانید...

Vote count: 0 Lets say I have a calculated column:- select str_to_map("k1:1,k2:2,k3:3")["k1"] as col1, str_to_map("k1:1,k2:2,k3:3")["k2"] as col2, str_to_map("k1:1,k2:2,k3:3")["k3"] as col3; How do I 'fix' the column calculation only once and access its value multiple times in the query? The map being calculated is the same, only different keys are being accessed for different columns. Performing the same calculation repeatedly is a waste of resources. This example is purposely made too simple, but the point is I want to know how to avoid this kind of redundancy in Hive in general. asked 27 secs agoDhiraj Let's block ads! بخوانید...

Vote count: 0 Hi we had used ejabberd 16.04 version for chat application, and i can perform user creation and sending message now what i need is i want to archive messages but i couldn't so kindly look into below code and guide me where i went wrong? Some of the my ejabberd code: auth_method: sql default_db: sql Database coection: ## ## MySQL server: ## sql_type: mysql sql_server: "127.0.0.1" sql_database: "ejabberd" sql_useame: "root" sql_password: "1231231213" modules: mod_mam: db_type: sql Error log: 2016-07-18 12:36:49.039 [waing] @ejabberd_config:default_db:884 Module 'mod_carboncopy' doesn't support database 'sql' defined in option 'default_db', using 'mnesia' as fallback asked 55 secs...

Vote count: 0 Could you tell me how to transform. hive transformation question asked 35 secs agobrijesh MISHRA Let's block ads! بخوانید...

Vote count: 0 I have a table with the schema as shown below: CREATE TABLE Table1 (membertype varchar(1)); INSERT INTO Table1 (membertype) VALUES ('Y'),('H'),('U'),('W'),('W'),('W'),('H'),('H'),('U'), ('U'),('P'),('P'),(''),('P'),('P'),('P'),(''),('W'), ('Y'),('Y'),('Y'),('H'),('D'),('D'),('D'),('D'),('H'), ('W'),('W'); What I am trying to achieve is to get the count of each type in the column and also their percentage to the total number of types in the column. I tested the below query in MYSQL and got the desired result: select (case when m.membertype='Y' then 'Young Adult' when m.membertype='H' then 'Head' when m.membertype='W' then 'Spouse' when m.membertype='P' then 'Aged Parent' when m....

Vote count: 0 I'm trying to produce a fully refreshed set of numbers each week, pulling from a table in hive. Right now I using this method: SELECT COUNT(DISTINCT case when timestamp between TO_DATE("2016-01-28") and TO_DATE("2016-01-30") then userid end) as week_1, COUNT(DISTINCT case when timestamp between TO_DATE("2016-01-28") and TO_DATE("2016-02-06") then userid end) as week_2 FROM Data; I'm trying to get something more along the lines of: SELECT Month(timestamp), Week(timestamp), COUNT (DISTINCT userid) FROM Data Group By Month, Week But my week runs Sunday to Saturday. Is there a smarter way to be doing this that works in HIVE? asked 48 secs agoDick McManus Let's block ads! بخوانید...

Vote count: 0 I followed the tutorial here http://www.tutorialspoint.com/hive/hive_installation.htm to install HIVE but I am getting this error when ruing bin/hive. Hadoop is ruing as I am able to access http://localhost:50070/dfshealth.html#tab-overview hduser@nikhil-Lenovo-IdeaPad-Y500:/usr/local/hive$ bin/hive SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/local/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an...

Vote count: 0 I created partitioned table with userc and coding as partition columns. When i am inserting data from another table it inserts into it without any issues for individual months however when i am trying to insert data of different months into 1 parition table , i start getting error like loading (userc=null, coding=null) Failure Kindly find screenshot for more information I double cross-verified, i dont find any record with userc and coding as null. enter image description here asked 38 secs agoAnk Let's block ads! بخوانید...

Vote count: 0 I need to write hive queries to get the number of rows for a Website. This needs to be an Oozie script (if possible) which would run bi-weekly and send a mail as a response. The script should send mail of number of all the new records generated (after a specific Date) as well as total number of records till date. The script would read a file (which contains a set of website names) for which the query would be generated and response would be generated. I am new to Oozie. How should I go about this. asked 3 mins agoKavya Sahai Let's block ads! بخوانید...

Vote count: 0 I am trying to stream in spark and insert into hive.I want to insert joinKey object to hive.and I cam to a point where I have the code like below.From here How do I insert to Hive. Joinkey joinkey= new Joinkey(); finalRDDStream.foreachRDD(new VoidFunction() { private static final long serialVersionUID = 1L; @Override public void call(JavaPairRDD arg0) throws Exception { arg0.collect().forEach(x -> { DetailKey key = x._1; joinkey.setDate(key.getDate().toString()); joinkey.setName(key.getName()); joinkey.setId(key.getId()); joinkey.setCellNo(x._2._1); joinkey.setUrl(x._2._2); }); } }); I am trying something like below to insert to hive..But it doesnt seem to be correct finalRDDSt...

Vote count: 0 Objective: Just trying to create a simple table in hive hive> create table employee(emp_id int, name string, salary double) row format delimited fields terminated by ','; FAILED: Execution Error, retu code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB coections, we don't support retries at the client level.) hive> Please note that I have download the apache hive and have not configured derby asked 1 min agoRaghvendra Mishra Let's block ads! بخوانید...

Vote count: 0 Is it possible to direct that input from this command to a file and also to standard output? tar -t all.tar Also Is there a way to kill all processes ruing lets say an xclock? asked 1 min agoJimBob101 Let's block ads! بخوانید...

Vote count: 0 I have a table X ID A B -------------- 1 abc 27 1 - 28 2 - 33 3 xyz 41 3 - 07 I need output as ID A B -------------- 1 abc 27 2 - 33 3 xyz 41 I tried doing max(A) OVER (PARTITION BY ID) as the_value but it did not work. I can still see all the rows in the output table. I was wondering if somebody has come across a similar situation and has a solution to this ? asked 1 min agopavan kulkai This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers....

Vote count: 0 Just wondering if anyone knows how to fix this error. I am trying to submit my app via, Xcode 7 -> Archive -> Submit to app store. I have validated the app and it has been approved. But when i try to submit it i keep getting this error. Any ideas? asked 6 mins agoJames This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers....