sql - Why "SELECT COUNT(DISTINCT <Column>) FROM <Table>" return 0? -

-

i have run query above columns in massive table (billion rows) , fine except couple returning 0. how possible?

count(distinct) can return 0 under 2 circumstances. first values column/expression evaluate null. second where clause (or join) filters out rows.

if have no where or join, values null <columnb>.


Comments

Post a Comment

Popular posts from this blog

php - Admin SDK -- get information about the group -

-
please, help. https://www.googleapis.com/admin/directory/v1/groups/106274944935548788283 sending request obtain information group id 1062 ... here link method in google https://developers.google.com/admin-sdk/directory/v1/guides/manage-groups#get_group in response error - 401 unauthorized. oauth authenticate via user has received rights necessary request, included in console admin sdk. authorization successful, there token. not can not understand. if not hard - response. requested information: file_get_contents("https://www.googleapis.com/admin/directory/v1/groups/1062749‌​44935548788283?key=aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4"); id group - "106274944935548788283" key applications in case - "aizasybruhiomdf9nlx9lx3imxwesqmcrnhh4l4" error: failed open stream: http request failed! http/1.0 401 unauthorized
Read more

ruby on rails - one-to-many through referance table -

-
i'm trying understand how implement one-to-many relationship through reference table. i'm looking on this guide though write on 1 model has_many one-to-many i'm not sure (i wrote it's not working). anyway i'm doing save me table, , doing right , not working. the model following: microposts, :id, :content tag, :id, :name tag_microposts, :tag_id, :micropost_id article, :id, :text article_microposts, :article_id, :micropost_id i can 2 microposts tables id of tag/article. think doing better , righter. in end what's interesting me microposts through tag model. in tag_controller able do: def index @tag = tag.find(params[:id]) @microposts = @tag.microposts end some code: class tag < activerecord::base ... has_many :tag_microposts, foreign_key: :tag_id, dependent: :destroy has_many :microposts, through: :tag_microposts, source: :micropost ... end class tagmicropost < activerecord::base validates :tag_id, presence: true v...
Read more

java - How to execute tasks in ExecutorService sequentially? -

-
i have 3 threads joined, i.e. second thread executes after first dies. this code have: public class main { public static void main(string args[]) throws exception { final thread thrda = new thread(() -> system.out.println("message 1")); final thread thrdb = new thread(() -> system.out.println("message 2")); final thread thrdc = new thread(() -> system.out.println("message 3")); thrda.start(); thrda.join(); thrdb.start(); thrdb.join(); thrdc.start(); thrdc.join(); } } how implement functionality using executorservice instead of 3 thread objects? if want/need execute group of jobs 1 after in single thread different main app thread, use executors#newsinglethreadexecutor . executorservice es = executors.newsinglethreadexecutor(); es.submit(() -> system.out.println("message 1")); es.submit(() -> system.out.println("message 2...
Read more